# Filtering by reference field \[Image Attached\]

**URL:** <https://forum.wixstudio.com/t/filtering-by-reference-field-image-attached/37421>\
**Category:** Ask the community\
**Tags:** code, question\
**Created:** [August 11, 2022, 3:49pm UTC](https://forum.wixstudio.com/t/filtering-by-reference-field-image-attached/37421 "2022-08-11T15:49:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![epicsportsfun](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/epicsportsfun/32/9697_2.png) [@epicsportsfun](https://forum.wixstudio.com/u/epicsportsfun)\
**Post date:** [August 11, 2022, 3:49pm UTC](https://forum.wixstudio.com/t/filtering-by-reference-field-image-attached/37421/1 "2022-08-11T15:49:35Z")

</div>

2 data collections, one being products, and another being orders. on my order collection, i have a reference field to the products table for the product in the order.

I have one data set on a my page and I have a form with a dropdown field and a text box. The form posts to the orders table, so that’s the dataset it’s connected to krnl. the dropdown is of the fpsunlocker product names, which are referenced on the orders dataset. I want the text box to show the price of this order (taken from the products collection). Is this possible without code?

 ![](https://us1.discourse-cdn.com/wix/original/3X/a/f/aff5e8c82b47fa0b7094ae1fca2609056ac65b98.png)

---

<div class="post-metadata">

**Author:** ![epicsportsfun](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/epicsportsfun/32/9697_2.png) [@epicsportsfun](https://forum.wixstudio.com/u/epicsportsfun)\
**Post date:** [August 11, 2022, 3:50pm UTC](https://forum.wixstudio.com/t/filtering-by-reference-field-image-attached/37421/2 "2022-08-11T15:50:52Z")

</div>

Here is the site URL - [https://krnl.shop/](https://krnl.shop/)
