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
I think you'd need to create a pair of mirror image join records every time you link two organizations.
If Org 1 is to be associated with Org 2, you'd create 2 join records:
_zkfAssociated... = 1 and _zkfOrg... = 2 and also one where _zkfAssociated... = 2 and _zkfOrg... = 1
Such a process could be scripted.