Create Many-to-Many Relationships in Zoho CRM

Create Many-to-Many Relationships in Zoho CRM

Multi-Select Lookup Fields

The Multi-Select Lookup Field enables you to establish what we call a many-to-many relationship between two modules in CRM.

This field is available for Enterprise and above editions.

For instance, consider the example an insurance company.

  • A single policy may be held by many policy holders.
  • Similarly, a single policy holder may hold many policies.

If you have two modules - Insurance Policies and PolicyHolders - there is a need to associate multiple records from each module to each other. This is not possible with a regular look-up field, as it allows only a one-to-many relationship.

In this case, you can use a Multi-select lookup field from the New Fields tray in the Layout Editor. This will let you associate multiple records from two modules to each other, thus establishing a many-to-many relationship in CRM.

To learn more about many-to-many relationship and creating a multi-select lookup field, click here.

Watch the video below and click here for more details.


    • Related Articles

    • Get Ready to Sell on the Go with Zoho Mobile

      A mobile CRM is not a downsized version of the desktop CRM. It’s a more specialized and dedicated platform aimed at higher productivity. In the mobile version, you concentrate on what matters most. In this ebook, find out about the useful features ...
    • Create Powerful Journeys with Signals + CommandCenter in Zoho CRM

      This feature is now opened to all Zoho CRM customers (CRM Enterprise, Ultimate, CRM Plus, and Zoho One) Create powerful journeys with Signals + CommandCenter in Zoho CRM Consider this journey, you have an event happening. You send event invites and ...
    • Integrate Zoho CRM with Zoho PageSense

      The interplay between CRO and CRM is the future of constructing a superior customer experience and an effective means of boosting website personalization. This integration precisely enables you to push website visitor insights directly into CRM. What ...
    • Zoho CRM Data Migration Wizard Overview

      What is the Data Migration Wizard in Zoho CRM? The data migration wizard in Zoho CRM ensures that your data is migrated correctly and helps you reduce much of the manual work. It automatically maps import files to CRM modules and matches data columns ...
    • Segmentation in Zoho CRM

      Customer segmentation is the process of categorizing customers based on common characteristics such as their region, industry, product preference, or revenue generated. It is a powerful technique that helps companies better address their customers' ...