Expanded list by mapping 3 objects

Hi Community,

 

I have three objects: Contact, Accounts details, AccountContact. Contacts has contact details unique on email address. Contact and Accounts details have many to many mapping with AccountContact being the mapping table. We have created lookups in accountcontact table on contact and accounts to get the mapping. Now we want to show all the accounts in Accounts details for a contact in an expanded list on the contact form page. How do we reach from contact object to accounts via accountcontact object? Screenshot of the properties of expanded list attached

Like 0

Like

1 comments

Hi,

Unfortunately, I didn't fully understand your task. Could you please provide a schematic representation of the table relationships and the data you want to display on which page?

Show all comments