1 Reply Latest reply on Apr 7, 2011 10:48 AM by philmodjunk

    Displaying Related Records From Same Table

    DuncanB

      Title

      Displaying Related Records From Same Table

      Post

      Forgive the no doubt basic question, but any help much appreciated. I have an Organizations table. Two organizations are related to one another (a record label and a band for example, each their own organization, but linked).

      I wish to show the related Organizations via a portal on the Organization layout. I have created a join table with OrgID and RelatedOrgID and created the portal. It works when looking at one record, but when looking at the other record, the link the other way doesn't show. I could create two join records for each relationship, but I'm thinking there's a smarter way...

      I don't wish to get into creating more tables. I've attached the relationship graph if that helps. Many thanks

      Graph.jpg