Hello Group, I hope I'm in the right place, if not, I'd appreciate some help in where to post this question. I'm in desperate need of a solution today !

My problem

3 tables

1 - Orders

2 - Lines (Orders)

3 - Products : 5 types

Goal : Place a purchase in the Orders file. This file will contain 3 portals (from the Lines table) :

Portal 1 : Size

Portal 2 : Color

Portal 3 : Extras

I would like to have these pop-ups display a list of Only the “related products” when the portal row is clicked into. So, if the “Size” portal is selected, a list of all the “Sizes” will appear.

I can do this easily if the all the fields concerned are in the same table but need help if FM must go into another table for the list.

Any help would be greatly appreciated; it’s 2 full work days that I have spent trying to find a solution !

Thanks.

If I understood you correctly, the attached file should contain a solution for you.

OrdersProductsSizes.fp7.zip