I've read the community forums and found most recommendations for linking multiple accounts to a single contact to be that of connection roles.
However, I've not been able to determine how I can utilise that outside of just creating those connections.
For context, I have a table that tracks participation of events by our contacts. I'd like to have a field that references a list of organisations that a contact can represent.
Example:
Contact A is tied to a parent account Organisation X, with a designation of CEO.
Contact A is also a board Chairman in Organisation Y.
Contact A joins an event hosted by my company, but he is participating in the capacity of his role as a chairman in Org Y, not in the capacity of CEO in Org X where he works.
Is there a way to create a column in my Event Participation table where I can lookup to all organisations tied to Contact A, and select the organisation he is representing? i.e. either Org X or Org Y.
