# Filtering by reference field

**URL:** <https://forum.wixstudio.com/t/filtering-by-reference-field/18106>\
**Category:** Ask the community\
**Tags:** code, question\
**Created:** [June 13, 2019, 3:34am UTC](https://forum.wixstudio.com/t/filtering-by-reference-field/18106 "2019-06-13T03:34:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sanketshahc](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/sanketshahc/32/12635_2.png) [@sanketshahc](https://forum.wixstudio.com/u/sanketshahc)\
**Post date:** [June 13, 2019, 3:34am UTC](https://forum.wixstudio.com/t/filtering-by-reference-field/18106/1 "2019-06-13T03:34:15Z")

</div>

Hi, Say I have:  
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. the dropdown is of the 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?

Seems like it should be, but I’m not able to do it because I can’t filter by the reference field.

---

<div class="post-metadata">

**Author:** ![givemeawhisky](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/givemeawhisky/32/5383_2.png) [@givemeawhisky](https://forum.wixstudio.com/u/givemeawhisky)\
**Post date:** [June 13, 2019, 1:11pm UTC](https://forum.wixstudio.com/t/filtering-by-reference-field/18106/2 "2019-06-13T13:11:51Z")

</div>

Have a read of these pages.  
[https://support.wix.com/en/article/about-reference-fields-in-database-collections](https://support.wix.com/en/article/about-reference-fields-in-database-collections)  
[https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931](https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931)  
[https://support.wix.com/en/article/working-with-multiple-item-reference-fields](https://support.wix.com/en/article/working-with-multiple-item-reference-fields)  
[https://support.wix.com/en/article/about-referencing-multiple-items-in-one-field](https://support.wix.com/en/article/about-referencing-multiple-items-in-one-field)

---

<div class="post-metadata">

**Author:** ![sanketshahc](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/sanketshahc/32/12635_2.png) [@sanketshahc](https://forum.wixstudio.com/u/sanketshahc)\
**Post date:** [June 13, 2019, 2:06pm UTC](https://forum.wixstudio.com/t/filtering-by-reference-field/18106/3 "2019-06-13T14:06:40Z")

</div>

I’ve read all of these. They’re not quite the same example.
