AnsweredAssumed Answered

Displaying Related Records From Same Table

Question asked by DuncanB on Apr 7, 2011
Latest reply on Apr 7, 2011 by philmodjunk


Displaying Related Records From Same Table


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