Results 1 to 9 of 9

Thread: Create a many to many relationship from Accounts to Contacts?

  1. #1
    Asinproject is offline Member
    Join Date
    Feb 2010
    Posts
    7

    Default Create a many to many relationship from Accounts to Contacts?

    Hi,

    I'm developing our CRM as a contact management tool for a non profit. Many of our contacts may be the director of one organization and a board member for another... is it possible to associate one contact with multiple accounts?

  2. #2
    salesagility's Avatar
    salesagility is offline Sugar Community Member
    Join Date
    Aug 2006
    Location
    UK
    Posts
    2,494

    Default Re: Create a many to many relationship from Accounts to Contacts?

    Yes ... a single Contact can be related to as many Accounts as you require ... goto Accounts > Contacts subpanel and click select
    The Open Source Awards are back For 2014

    Check out the open source awards at opensourceawards.org

    Committed to Open Source

    SalesAgility - SugarCRM Community Edition Experts

    Authors of:

    Advanced Open Sales - Quotations, Invoices, Products, PDF Templates and Contracts modules for SugarCRM Community Edition
    Advanced Open Workflow - Workflow for SugarCRM Community Edition
    Advanced Open Events - Events module for SugarCRM Community Edition
    Advanced Open Portal - Portal for SugarCRM Community Edition
    Suite CRM - SugarCRM supercharged!!

  3. #3
    Asinproject is offline Member
    Join Date
    Feb 2010
    Posts
    7

    Default Re: Create a many to many relationship from Accounts to Contacts?

    Thanks for your response! Could you elaborate on how this is done? I did not totally understand your answer. Thanks again!

  4. #4
    anicolais is offline Senior Member
    Join Date
    Nov 2009
    Posts
    99

    Default Re: Create a many to many relationship from Accounts to Contacts?

    Go to whichever account that you want to add an existing contact to. Scroll down to the contacts subpanel at the bottom of the page. Instead of clicking "Create new contact" click "Select" instead. This will pop up a window to search from existing contacts to be added to the account that you would like.

  5. #5
    tomcdonnell is offline Senior Member
    Join Date
    Mar 2010
    Posts
    23

    Default Re: Create a many to many relationship from Accounts to Contacts?

    If an existing contact is linked to a another account using the method desribed, a new contact is created. The new contact has all details equal to the pre-existing contact except 'Account Name'. This can be verified by searching for the contact in the 'Contacts' tab. The new contact that is created is undesirable since it contains duplicate data that must then be kept synchronised with the data from the original contact.

    I want to link the same contact to multiple accounts. I figure this should be possible because the relationship between the 'Accounts' and 'Contacts' modules is listed in the studio as being 'Many to many'.

    That only one account can be displayed in the 'Contacts' module detail view seems odd given the 'Many to many' relationship.

    Can anyone shed some light on how to assign a single contact to mulitple accounts?

    If this is not possible for some reason, then an explanation as to the meaning or purpose of the 'Many to many' relationship linking 'Contacts' to 'Accounts' would be much appreciated also.

  6. #6
    salesagility's Avatar
    salesagility is offline Sugar Community Member
    Join Date
    Aug 2006
    Location
    UK
    Posts
    2,494

    Default Re: Create a many to many relationship from Accounts to Contacts?

    If you wish one Contact to be related to many Accounts, simple goto the Accounts that you wish the Contact to be related to, scroll down to the Contacts subpanel and Select the Contact. You can do this for as many Accounts as you wish.
    The Open Source Awards are back For 2014

    Check out the open source awards at opensourceawards.org

    Committed to Open Source

    SalesAgility - SugarCRM Community Edition Experts

    Authors of:

    Advanced Open Sales - Quotations, Invoices, Products, PDF Templates and Contracts modules for SugarCRM Community Edition
    Advanced Open Workflow - Workflow for SugarCRM Community Edition
    Advanced Open Events - Events module for SugarCRM Community Edition
    Advanced Open Portal - Portal for SugarCRM Community Edition
    Suite CRM - SugarCRM supercharged!!

  7. #7
    tomcdonnell is offline Senior Member
    Join Date
    Mar 2010
    Posts
    23

    Default Re: Create a many to many relationship from Accounts to Contacts?

    I found a solution in another thread. An 'Accounts' subpanel must be added to the 'Contacts' detail view. Instructions on how to accomplish that are given here: http://www.sugarcrm.com/forums/showthread.php?t=56953. The method described worked for me.

  8. #8
    Join Date
    Jan 2011
    Posts
    19

    Question Re: Create a many to many relationship from Accounts to Contacts?

    Apologies for the thread necromancy ........ though, is there a way of adding "is-a" data to a relationship.

    For instance if I have 2 companies A and B. I need to have contacts for 3 roles within each company.

    Company A is a 1 person outfit so each is the same :

    CTO : Bob Smith
    COO: Bob Smith
    CFO: Bob Smith

    Though B is a much bigger company and we have :

    CTO : Betty
    COO: Frank
    CFO: Mary

    My initial thoughts were either, define the type of relationships of the contact ......... OR have custom fields in the company for each of the roles that are links to contacts that must exists (the usual drop down).

    Thanks for any suggestions or insights

  9. #9
    vakimby is offline Junior Member
    Join Date
    Dec 2011
    Posts
    3

    Default Re: Create a many to many relationship from Accounts to Contacts?

    Quote Originally Posted by Jeremy Hutchings View Post
    Apologies for the thread necromancy ........ though, is there a way of adding "is-a" data to a relationship.

    For instance if I have 2 companies A and B. I need to have contacts for 3 roles within each company.

    Company A is a 1 person outfit so each is the same :

    CTO : Bob Smith
    COO: Bob Smith
    CFO: Bob Smith

    Though B is a much bigger company and we have :

    CTO : Betty
    COO: Frank
    CFO: Mary

    My initial thoughts were either, define the type of relationships of the contact ......... OR have custom fields in the company for each of the roles that are links to contacts that must exists (the usual drop down).

    Thanks for any suggestions or insights
    Did you ever figure out how to customize the role of the contact at each account? We need to do the same thing. Thanks!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Contacts and their relationship to Accounts?
    By messageimpact in forum Help
    Replies: 5
    Last Post: 2009-11-24, 10:37 AM
  2. Contacts Accounts Search Relationship
    By Jax.Smith in forum Help
    Replies: 2
    Last Post: 2009-08-04, 06:43 PM
  3. Relationship between Contacts and Accounts
    By chrislynch8 in forum Help
    Replies: 1
    Last Post: 2009-07-16, 03:18 PM
  4. Replies: 2
    Last Post: 2009-05-11, 01:44 AM
  5. Contacts <--> Accounts relationship data
    By bokonon in forum Developer Help
    Replies: 3
    Last Post: 2006-12-18, 10:23 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •