Link a single Contact to multiple Accounts - Contact is not in every selected Account-Contactlist - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Christopher DübeChristopher Dübe 

Link a single Contact to multiple Accounts - Contact is not in every selected Account-Contactlist

Hello Ladies and Gentlemen!

I already found several topics in the community about linking a single contact to multiple accounts. Mostly they try to solve this problem with contactroles.

In my case I created a second field (look-up-field) called "Accountname 2". The assignment works perfectly. The problem is that I am not able to see the contact in the contact-overview of the accounts. The contact is always listed the the first account and not the in the secound account.
 
I also have the same problem with contact-roles.

Does anybody have a solution for this topic?

Kind regards, 

C.Dübe
Rupert BarrowRupert Barrow
Christopher,
By creating a second Account lookup on Contact, you also created a second Contacts related list on Account : if you look at the Page Layout of Account, you will be able to add it in the Related Lists section.

If you want to implement a more general solution, you will need to configure a many-to-many relationship between Account and Contact : you can have a look here :
http://help.salesforce.com/HTViewHelpDoc?id=relationships_manytomany.htm&language=en_US

Good luck,
Rup
Damien OwenDamien Owen
+1 Rupert - many-to-many relationship is the way forward here. You need to create a custom object to act as a custom object. The junction object would need to have a master-detail to the account object and a master-detail to the contact object. 
Thomas TaylorThomas Taylor
The Salesforce Foundation's Affiliations app (https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003GLGFEA4) is free and creates that one-to-many relationship and provides some additional useful tools for managing it. It's part of the Nonprofit Starter Pack, but stands alone and doesn't have any nonprofit-exclusive functionality; it just solves a need that a lot of nonprofits have.