1 Reply Latest reply on Oct 10, 2012 1:06 PM by philmodjunk

    How to view records through a portal

    PeterMontague

      Title

      How to view records through a portal

      Post

           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.

      relationships.jpg

        • 1. Re: How to view records through a portal
          philmodjunk

               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.