Creating Many to Many relationship between the accounts records in salesforce

Question

Is there a method to link one account record to multiple additional account records in Salesforce using a many-to-many relationship format? We can't construct many-to-many relationships with the same object type in Salesforce, therefore this isn't doable the traditional method. Could someone please offer a special method or code to accomplish this? I have a need to link Account A with Account B and Account C, for example, so that I may access Account B and C's contacts on Account A.

Answer 1

In Salesforce, you'll need a joiner object with two master-details to account for a many-many relationship (There is actually already a standard object called Partner that may fit your needs).

It's definitely easier to construct a simple visualforce page that queries and displays the contacts of connected accounts to see the contacts of associated accounts.