How to view records through a portal
I would like to view categories through a portal in my inventory table. I set up the portal but can see no records in it.
This is what the relationships look like.
Your current relationship goes from Inventory to This to Category. No records will appear in the portal unless there is also a record in This with a matching SKU to link to the current record in Inventory and a matching Product_id that matches to one or more records in category.
I'd make a new occurrence of Category, link it to Inventory by Product_id and then make the portal a portal to this new table occurrence.
Retrieving data ...