Filtering in child table

[Natt_Boarer]

Could someone point me in the right direction.

I'm building a "goods in" app. In the "Purchase Order Table" one can choose a supplier (Supplier Name), and then after selecting the Supplier, one can add line items to the Purchase Order in a referenced table called "Line Items".

In the line items table, I have   SORT(GoodsSupplied[Item Name]) - I've been trying to filter ITEM NAME to show only items from the supplier chosen in the Purchase Order Form. 

Can somebody point me in the right direction on how to select "Supplier" from the PO table?

[AleksiAlkio]

If you need only the already selected, use Deref like [Purchase Order].[Supplier Name]

[Natt_Boarer]

So I had tried this already as follows - 

SORT(SELECT(GoodsSupplied[Item Name],[_THISROW].[Item Name]=[PO].[Supplier]))

but it just breaks the form...

[AleksiAlkio]

The list is not needed if you just want to read it from the parent record.

[Natt_Boarer]

So the reason I want a list is because I'm reading suppliers in order to return a list of supplied goods per the supplier selected on the PO form... 

[AleksiAlkio]

Sorry, I misunderstood your request. It would be something like..

SELECT(GoodsSupplied[Item Name],[Supplier]=[_THISROW].[PO].[Supplier])

[Natt_Boarer]

This is giving me a similar error - Unable to find column 'PO'

[AleksiAlkio]

Use your Ref column name that you have in "Line Items" table

[Natt_Boarer]

That's got it! Thanks so much!

[AleksiAlkio]

You're welcome!