Hello Group,

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

These portals will get their info from the Products file.

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 !

Mac Os 10.4.9, FMP 8.5 Advanced