Associate a contact with multiple companies or accounts

Associate a contact with multiple companies or accounts

Edition: Enterprise and above | Industry: Applicable for all industries | Features: Multi-select Lookup Field and Module Customization

Scenario:
A wealth and asset management consultancy helps customers connect with a suitable financial advisor in their area. Depending on the clients portfolio, they may require more than one advisor to manage their assets. In these cases, one client will be connected to multiple advisors and, at the same time, one advisor will be connected to multiple clients. In order to recommend the right advisor, the consultancy needs to have a holistic view of its advisors and the clients they are currently engaged with.
Requirements:
The firm has to establish a connection between the clients and advisors, such that:
  1. One client is associated with multiple advisors
  2. One advisor is associated with multiple clients
Solution:
Jonas is the account manager and CRM administrator at the consultancy. He needs to connect the advisors and clients so that they can see the list of advisors that are associated with a client and vice versa. To do this, he needs to:
  1. Customize the CRM account: Rename the Accounts and Contacts modules to Advisors and Clients, to store details of the clients and advisors the firm does business with.
  2. Establish many-to-many-relationship: Add a multi-select lookup field to the Clients layout.
To add a multi-select lookup field do the following:
  1. Go to Modules and Fields, select the Clients module and then the Standard layout.
  2. Drag and drop the multi-select lookup field onto the layout and enter the following values:
  3. Field name

    Value

    Field label

    Advisors

    Select related module

    Advisors

    Field label in related module

    Associated advisors

  4. Check Allow creating relationship-specific module and click Done.
This will allow the agents to:
  1. View the list of advisors that a client works with in the related list.
    For example, in the image below, Paul Smith is the client who is associated with the following advisors: John, Nathan, Alicia, and Kevin.
  2. View the list of clients that an advisor is dealing with in the related list.
    For example, in the image below, Nathan Brooks is the advisor who is associated with the following clients: Paul, Phill, and Albert.
  3. Get all the details of the client, the advisors they work with, and all related activities in the linking module.

  4. Enter criteria in the advanced filter to find records quickly.
  5. Generate a report to summarize the number of managed and held-away assets, the number of pending assets, the average number of clients managed by each advisor, the asset type that generates the most revenue, and more.

    • Related Articles

    • Can I sync one google contact folder with multiple CRM accounts?

      No, you can sync only one google contact folder with one CRM account. The folders that are already associated with CRM accounts will be greyed out (screen below).
    • Can I create multiple sandbox accounts using multi-org feature?

      Yes, a CRM user can create up to 10 sandbox accounts and be a Super Admin in up to five accounts. Any CRM user who has the permission to create sandbox can create upto 5 accounts. Read more about creating multiple CRM accounts. Refer to this page to ...
    • Can I sync data between multiple CRM accounts?

      No, the multi-org functionality does not allow any kind of data sync between the orgs. The sole purpose of creating multiple accounts is to provide users with ease of access. You can however, import/export data or use functions to transfer data ...
    • How can we associate one contact to many accounts without duplication?

      If you have many accounts associated with a common contact, for example one business owner may be part of three or four accounts. You will have to enter the owner's name four times to associate all the activities to the respective accounts. In such ...
    • Creating Accounts

      In Zoho CRM, you can create accounts by: Entering data in the account details form: You can manually fill in the Account details gathered from various external sources. Importing Leads from external source: You can gather data through various sources ...