I am trying to set up a tab with a portal on it for an inventory system I have. I want this portal to show all other items with the same Set ID as the record I am on.
The information is supplied from two locations firstly a Set ID and purchase order number from the Inventory table. Secondly the Item type and cost is supplied from a separate Items table which is connected to the first by an Item ID.
When I have set up the Portal I have set the following
Firstly to show records from a second occurrence of the table the portal is on. (Inventory 2)
Then a sort by the Inventory ID number( the number record in the inventory table)
It is then filtered by the following " Inventory 2::_kf_Set_ID = $$SetID"
The field $$SetID is set on tab entry as a copy of the set Id field on the main tab via a script trigger.
This returns all of the items in that Set but only the ones which have the same Item ID number.
I have attached a picture of my relationships graph below to try and explain a little better. (I have also attached images of my layouts if needed)
I am still a massive novice at filemaker and teaching myself as I go along so please forgive me if this is a stupid mistake