Filtering by reference field

Ask the community
,
1

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.

2

Have a read of these pages.
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/working-with-multiple-item-reference-fields
https://support.wix.com/en/article/about-referencing-multiple-items-in-one-field

3

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