Portal Needs to be more Specific
Hope someone out there can give me some direction on portals.
I've set on up in my database, selected the fields I want info back..Ex Service date, Serial Number, Notes. I am trying to get the service notes I wrote up during a servicing on a specific monitor (serial number) on various service dates. Everything works ok except the notes I get back and the serial numbers are not specific to the item, they are specific to the company that owns the equipment. The portal is displayed on a inventory record/database with specific info for that item. Each item has its own inventory record with specifics on that item. I am trying to get the specific notes displayed in the portal for the specific serial number on that inventory items record page.
Add a relationship that matches to the portal table by the serial number fields. Use that relationship as the basis for your portal.
You can add a new occurrence of the portal's table and use it for this relationship if you need the current relationship for other purposes.