Multiple record association in Zoho CRM

Multiple record association in Zoho CRM

When you manage your sales data in CRM, there is often a need to link two modules. For instance, when you click on an account, you can see the contacts associated with it. As you may already know, this is achieved with the help of a Lookup field which links Accounts with Contacts.

However, notice that this lookup field allows the association of multiple contacts to an account - but not multiple accounts to a contact. If at all you have contacts on contract who work with multiple companies, you cannot capture that association in CRM using the lookup field. 

Similarly, consider the example of an educational institution. A single student may opt for multiple courses. A single cour se may be taken by multiple students - so there i s a  two-way multiple association.  In systems analysis, this is referred to as many-to-many association. This many-to-many association between two modules in Zoho CRM is created with the help of the multi-select lookup field. 

Through this field, you can associate multiple students to a course, and vice versa.

Also, as part of this multiple association, you can create something called a Linking Module, which will record the details of each association. 

For instance, a student taking 5 subjects, will have a grade for each subject. This grade cannot be recorded in the Students module or the Courses module, as it will create duplicates. So you can create something called a Linking module, which will create each association as a record, and you can enter the specific details there. The linking module can be customized.

As you can see, the same student has different grades, for each course he/she has taken up. This information can be recorded in the linking module. This way, you can associate multiple records from two modules with each other. 

    • Related Articles

    • Zoho CRM: Associating Emails with Deals

      Do you have multiple deals associated to your contacts in Zoho CRM? Are you struggling to find deal specific emails, with all the emails associated with a contact listed together? If yes, then this tip is totally for you! You can associate emails ...
    • Zoho CRM: using Kanban view

      You deal with so many records in CRM every single day! When you click open each module in Zoho CRM, you have hundreds of records, each in various stages of your sales pipeline. Wouldn't it be cool if you had them all sorted automatically without ...
    • Zoho CRM: Run Macros to Save Time on Routine Tasks

      As sales reps, you meet customers every day. And after every visit, you do a set of actions in your CRM account like: You send an email to your customer to thank them for their time. You update the lead status as contacted. You also create a task to ...
    • Some time saving tricks in Zoho CRM

      Frustrated about doing the same operation on multiple records over and over again? The Mass functions in Zoho CRM come to your rescue, letting you filter a bunch of records using a criteria to transfer, delete or convert all of them or even update ...
    • Zoho CRM: Add new prospects from call popups

      If you've integrated your telephone provider in your Zoho CRM account, the calls that you make or receive inside Zoho CRM would have contextual business information. That way, you'd know details of any lead or contact who's calling you, before ...