filter on n:1 relation

htdave

I am trying to create a form with a filter.

I have an n:1 relation to allow the user to select the Supplier, and then enter details.

I also have a list showing all items, but I would like to filter the items shown, to only show items that have the Supplier that has been selected.

I have been trying all different filters, but can't seem to get it to show the correct results.

What filter should I be using to check that the chosen Supplier (F2) matches the supplier in the list?

Thanks

gabriel

htdave

Some things that look odd to me at first glance:

The filter should compare with "=", the LIKE operator is for comparing similar text values. Here you are comparing relationship IDs, which are numbers.
In the field F6: Why does the supplier relation also have a supplier attribute (s. screenshot below) - is that the supplier of the supplier? Ideally your filter in F6 should say: "field value: F2 = attribute: 0) ordering.supplier"

htdave

gabriel Thank you!

That is working now.
I wasn't sure if I was meant to be using the linked relation or not, so I had tried ordering.supplier and supplier.supplier.
I had tried the = but it was coming up with an error, but I obviously hadn't tried it with ordering.supplier.

Thank you again for all your help