Kaizen #199: FAQs on Multi-Select Lookup (MxN) Field in Zoho CRM
Nearing 200th Kaizen Post – We want to hear from you!
Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
Hey everybody!!!
Welcome back to another post in the Kaizen series!
In this post, we will address some of the most frequently asked questions about the Multi-Select Lookup(MxN) field from the Zoho CRM developer community forum.
1. What is a Multi-select lookup field?
A multi-select lookup field in Zoho CRM lets you create a many-to-many relationship between two modules. This means a record in one module can be linked to multiple records in another module and vice versa.
For example, using an multi-select lookup field, you can associate multiple skills with an employee.
2. How does the Mutli-Select Lookup relationship work?
When you create a Multi-Select Lookup between two modules, for example, Employees and Skills, Zoho CRM automatically creates a hidden linking module, which is also known as an MxN module. This module stores the associations between records in the two modules, enabling you to track and manage many-to-many relationships.
For instance, if you link Employees and Skills, a linking module named EmpXSkills will be created.
This linking module is accessible only via API.
Backend Flow of multi-select lookup Relationship
In the linking module, two lookup fields (lookup fields with api names - Employees and Skills) will be created. The lookup fields, one pointing to Employees and the other pointing to Skills from the linking module, establish a connection between the linking module and its associated module.
Why you cannot use a lookup field for this use case?
In Zoho CRM, a lookup field creates a one-to-many relationship between two modules i.e. one record in the source module can be linked to only one record in the target module.
Example :
If you create a lookup field for Skills in the Employees module, each employee can be linked to only one skill. So, use a multi-select lookup field instead of a lookup field when you need to represent complex relationships like one employee - many skills and one skill - many employees.
3. How to create a multi-select Lookup field using Zoho CRM APIs?
To create a Multi-Select lookup field between two modules using Zoho CRM APIs, follow these steps:
Step 1: Identify the Module API Name
Before creating the field, you should know the API names of the Employees and Skills modules. For that, use the Get Module Metadata API.
Request URL : {{api-domain}}/crm/v8/settings/modules
Request method : GET
Now, search for the Employees module in the response and note its API name.
Step 2: Use the Create Custom Fields API
To establish a many-to-many relationship between two modules, in our case, Employees and Skills, you need to create a custom field of type multi-select lookup in the Employees module (parent module). Here, we will associate multiple skills to an employee.
This custom field requires:
- The related module you want to link to - Skills.
- A display field from the related module
- The linking module (EmpXSkills), which stores the actual associations.
Use the Create Custom Fields API to create custom fields.
Request URL : {{api_domain}}/crm/v8/settings/fields?module=Employees
Request method : POST
Sample input :
|
{
"fields": [
{
"field_label": "Skills", //Name of the field in your module
"data_type": "multiselectlookup", //Type of the field
"multiselectlookup": { //This JSON object contains the multi-select lookup relationship details
"connected_details": { //Details about the module and field you want to link
"module": {
"api_name": "Skills" //API name of the related module
},
"field": {
"field_label": "Skills" //The field in the related module to display
}
},
"linking_details": { //Details about the junction or linking module that manages the many-to-many relationship
"module": {
"plural_label": "EmpXSkills" //Plural label of the junction module
}
}
}
}
]
}
|
4. How Do You Find the Linking Module and Field API Names?
To know the API name of the linking module:
Use the Get Modules API and search for "generated_type" : "linking" in the response to identify MxN modules. In our case, EmpXSkills.
Request URL : {{api_domain}}/crm/v8/settings/modules
Request method : GET
To know the field API names in the linking module:
Use the Get Fields Metadata API to retrieve the API names of lookup fields within the linking module.
Request URL : {{api_domain}}/crm/v8/settings/fields?module=EmpXSkills
Request method : GET
5. How do I associate records via a multi-select lookup field using the Insert Records API in Zoho CRM?
To associate records using a multi-select lookup field, you must provide the record IDs from the related module. The association is made through the linking module.
Example :
Associating multiple skills with an employee using the multi-select lookup field.
Request URL : {{api-domain}}/crm/v8/Employees
Request method : POST
Sample input :
|
{
"data": [
{
"Name": "Patricia",
"Email": "patricia@mail.com",
"Position": "Marketing Specialist",
"Year_of_Experience": 5,
"Skills": [ // API name of the multi-select lookup field in the Employees module
{
"Skills": { // API name of the lookup field in the linking module pointing to the Skills module
"name": "Marketing",
"id": "5725767000002149427" //ID from the Skills module are mandatory to establish the link
}
},
{
"Skills": {
"name": "Social Media Marketing",
"id": "5725767000002149476"
}
}
]
}
]
}
|
6. How do I associate an Employee's skills using the linking module in Zoho CRM?
To establish a relationship between the Employees and Skills modules through the linking module, use the Insert Records API to create a record in the linking module, EmpXSkills.
To do this,
- Use the appropriate lookup field API names to reference the parent module.
- You must need the record IDs from both the Employees and Skills modules to create the associations.
Request URL : {{api-domain}}/crm/v8/EmpXSkills
Request method : POST
Sample input :
|
{
"data": [
{
"Name": "Patricia",
"Employees": {
"id": "5725767000002161001" // Record ID from the Employees module
},
"Skills": {
"id": "5725767000002149476" // Record ID from the Skills module
}
}
]
}
|
7. When should I use create/update operations in the Employees module vs the EmpXSkills module?
|
Employees Module |
EmpXSkills (linking) Module |
|
Use when you want to create or update an Employee and associate Skills using the Multi-select Lookup field. |
Use when you want to create or remove associations between existing Employee and Skill records without modifying the actual Employee or Skill data. |
|
Creating a new employee and assigning their skills at once. |
Managing relationships between existing records i.e., linking and unlinking skills to employees. |
8. How to update a record in the linking module?
To update a record in the linking module, use the Update Records API.
Request URL : {{api-domain}}/crm/v8/EmpXSkills/5725767000006269044
Request method : PUT
Sample input :
|
{
"data": [
{
"Skills": {
"name": "Marketing",
"id": "5725767000002170035" //Associating another skill with the employee
}
}
]
} |
In the above sample, we have replaced an existing skill associated with an employee with another Skill in the linking module.This is done by updating the Skills lookup field in the EmpXSkills record.
Please note that in the linking module, Skills is a lookup field, so you can associate only one skill per linking record. But in the Employees module, Skills is a multi-select lookup field, so an employee can be associated with multiple skills.
9. How to unlink records from the parent module as well as the linking module?
Unlink the associated records from the parent module:
Using the Update records API, you can remove an associated skill from an employee, use the "_delete": null key within the multi-select lookup field in the Employee record update.
Request URL : {{api-domain}}/crm/v8/Employees/5725767000006269044
Request method : PUT
Sample input :
|
{
"data": [
{
"Skills": [
{
"Skills": {
"name": "Marketing",
"id": "5725767000002170035" // The Skill record you want to unlink
},
"id": "5725767000007228047", //record ID - The record created in the linking module for the employee with the Marketing skill
"_delete" : null
}
]
}
]
}
|
Replace an associated record from the linking module:
Use the Update Records API to replace an existing association in the linking module.
Request URL : {{api-domain}}/crm/v8/EmpXSkills/5725767000007228035
Request method : PUT
Sample input :
|
{
"data": [
{
"Skills": {
"name": "Java",
"id": "5725767000005259075" //replacing a new skill
}
}
]
}
|
In the above sample, we have replaced the existing skill with Java.
10. Why am I seeing the error "DUPLICATE_LINKING_DATA" in the Update Records API?
This error occurs when you try to associate records with the parent record that are already linked with the Multi-select lookup field. To resolve this, check the records you are trying to link and make sure your association is only with records that are not already linked.
Know your existing linked records:
Before the Update Records API, use the Get Related Records Data API and search for the multi-select lookup field. In our case, Skills is the multi-select lookup field created in the Employees module. This will return all records already associated.
Example :
The response returns all Skills already linked with that Employee.
Using this way, compare the IDs from the API response with the new records you are about to link, and only proceed with non-duplicate IDs. This avoids duplicate entries and prevents the "DUPLICATE_LINKING_DATA" error.
11. What happens if I delete a record in the linking module?
When you delete a record in the linking module, it only removes the association between the related records in the Employees and Skills modules.
Note :
- Deleting a linking module record removes only the relationship between two records from the Employees and Skills modules.
- Deleting an Employee or Skill record deletes all corresponding entries in the linking module as well.
12. How do I query linked records?
Use the COQL API to query multi-select lookup data by specifying the corresponding linking module's API name directly in your query. The linking module is treated as a separate module in Zoho CRM, so you can retrieve associated records by querying it like any other module.
Sample query :
|
{
"select_query": "select Skills.Name as skill, Employees.Name as employee from EmpXSkills where Skills.Name like '%Marketing%'"
}
|
Use the Get Module Metadata API to know the linking module's API name.
13. How do I export multi-select lookup records using the Bulk Read API?
To export multi-select lookup data, linking module records efficiently, use the Bulk Read API with the linking module’s API name.
Request URL : https://www.zohoapis.com/crm/bulk/v8/read
Request method : POST
Sample Request :
|
{
"callback": {
"method": "post"
},
"query": {
"module": {
"api_name": "EmpXSkills" //API name of the linking module
},
"fields": [
"Employees.Name",
"Employees.Year_of_Experience",
"Skills.Name"
],
"criteria": {
"group": [
{
"field": {
"api_name": "Employees.Year_of_Experience"
},
"comparator": "greater_than",
"value": "4"
},
{
"field": {
"api_name": "Skills.Name"
},
"comparator": "contains",
"value": "Social"
}
],
"group_operator": "AND"
}
}
}
|
14. Can I import my linking module's data using the Bulk Write API?
Yes. Like the Leads and Contacts modules, you can also import linking module's data into Zoho CRM using the Bulk Write API by directly specifying the linking module’s API name.
If you are importing data that involves both a parent module, Employees and its associated MxN linking module, follow these steps:
1. Create separate CSV files:
- One for the parent module - Employees
- One for the linking module - EmpXSkills
2. Zip the files into a single ZIP file.
3. Upload the ZIP in a single Bulk Write API request.
4. Ensure accurate field mappings are provided in the API request body.
Refer to Kaizen #131 - Bulk Write for parent-child records using Scala SDK for more details on handling parent-child records.
15. Can I receive notifications if a multi-select lookup field in a module is modified or updated?
Yes, you can receive notifications when a MxN field is updated using the Notification API. To enable instant notifications for actions performed in a module, use the respective API names of the linking module in the input body.
Request URL : https://www.zohoapis.com/crm/bulk/v8/actions/watch
Request method : POST
Sample input :
|
{
"watch": [
{
"channel_id": "10000",
"events": [
"EmpXSkills.all" //EmpXSkills represents the API name of the linking module
],
"notify_url": "https://webhook.site/9f5ba227-ce5a-4709-814d-b044c003d605",
"return_affected_field_values": true
}
]
}
|
16. Can I use criteria-based filtering when accessing multi-select lookup data using the Search API?
Yes, you can filter multi-select lookup data using the criteria parameter in the Search API's URL.
Here is an example that fetches records from the EmpXSkills linking module.
Request URL : {{api-name}}/crm/v8/EmpXSkills/search?criteria=((Secondary_Email:equals:patricia@mail.com)and(Skills:equals:Content_Marketing))
Request method : GET
Sample response :
x-----------------------------x
We trust that this post meets your needs and is helpful. Let us know your thoughts in the comment section or reach out to us at support@zohocrm.com
Stay tuned for more insights in our upcoming Kaizen posts!
Previous Kaizen Post : Kaizen #198: Using Client Script for Custom Validation in Blueprint | Kaizen Directory
Other FAQs in the Kaizen series :
- Kaizen#75 - Frequently Asked Questions on Client Script
- Kaizen #147 - Frequently Asked Questions on Zoho CRM Widgets
- Kaizen #155 - Frequently Asked Questions on Subforms
- Kaizen #170 - Frequently Asked Questions on Notification APIs
- Kaizen #195: Frequently Asked Questions on Bulk Read API and Bulk Write API
Access your files securely from anywhere
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Subramanian K
Sticky Posts
Kaizen #198: Using Client Script for Custom Validation in Blueprint
Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.Kaizen #226: Using ZRC in Client Script
Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In thisKaizen #222 - Client Script Support for Notes Related List
Hello everyone! Welcome to another week of Kaizen. The final Kaizen post of the year 2025 is here! With the new Client Script support for the Notes Related List, you can validate, enrich, and manage notes across modules. In this post, we’ll explore howKaizen #217 - Actions APIs : Tasks
Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.Kaizen #216 - Actions APIs : Email Notifications
Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes are
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Card payment surcharge?
Hi, I would like to offer my customers the ability to pay invoices by card (using the PayPal integration). However, PayPal charges me around 5% to receive a card payment, and I would like to pass on this cost to my customer by way of a card payment surcharge. Is there any way for Zoho Invoice to be set up to automatically add a defined "card processing fee", say 5% of the invoice total, if the customer elects to pay by card? I don't want to add this on to invoice manually, since most of my clientsZoho Books | Product updates | January 2026
Hello users, We’ve rolled out new features and enhancements in Zoho Books. From e-filing Form 1099 directly with the IRS to corporation tax support, explore the updates designed to enhance your bookkeeping experience. E-File Form 1099 Directly With theZoho POS App Hanging Issue – Sales Becoming Difficult
The Zoho POS app frequently hangs and becomes unresponsive during billing, making it very difficult to complete sales smoothly. This commonly happens while adding items, during checkout, or at payment time, especially during peak hours. These issues causeTip #62- Exploring Technician Console: Send Ctrl + Alt + Del- 'Insider Insights'
Hello Zoho Assist Community! This week, we’ll be exploring the Send Ctrl + Alt + Del option in the Technician Console. Let’s jump right in. System administrators often rely on Ctrl + Alt + Del when managing remote devices that have unresponsive applicationsSKUs for Invoices, POs, etc.
It doesn't appear that one can enable SKU display on invoices, POs, etc. This is problematic, and I don't see a good reason why this shouldn't be an option. Some of our vendors and customers use this in their system. Every other identifier code is availablehow to avoid duplicate customer
How can i avoid to create a duplicate customer. I charged a same customer with two different plans and it showed up twice in my customer list and subsequently in Zoho books contacts. It creates confusion to have a same customer appears multiple times in customer or contact list. How can i avoid it.RSC Connectivity Linkedin Recruiter RPS
It seems there's a bit of a push from Linkedin Talent Solutions to keep integrations moving. My Account Manager confirmed that Zoho Recruit is a Certified Linkedin Linkedin Partner but does not have RSC as of yet., (we knew that :-) She encouraged meim facing issue on generate the Estimate price
i couldn't understand what is the issue , i cant generate Estimate price where is the issuecannot be able to add user
Dear team I tried to add a new user for sales team, but after entering the OTP its showing error message cannot add nowChanging an existing item to different accounts & inventory-tracked
Hi everyone, I have an item in Zoho Books that was originally set up as a non-inventory item. Over time, I associated it with different sales and purchase accounts, and I now have many invoices, bills, and reports that use this item. My business processHow do I edit the Calendar Invite notifications for Interviews in Recruit?
I'm setting up the Zoho Recruit Interview Calendar system but there's some notifications I don't have any control over. I've turned off all Workflows and Automations related to the Calendar Scheduling and it seems that it's the notification that is sentBookings duration - days
Hi team, Is there any way to setup services/bookings that span multiple days? I am using Zoho Bookings for meeting room bookings. Clients may wish to book a room for more than one day, for up to a month. If not, is there a plan to allow services to be setup with durations of Days as well as hours and minutes? Many thanks, Anna.big 5 accounts
how do you find what accounts are listed as Big 5 ?Zoho recruit's blueprint configuration is not functioning as mapped
Current Status: Zoho Blueprint is not functioning as configured. Issue: We are moving a Candidate status in Zoho Recruit "for active file" but we encountered: "Status cannot be changed for records involved in Blueprint." This happens to various clientActual vs Minimum
Hi all, I am sure I am not the only one having this need. We are implementing billing on a 30-minute increment, with a minimum of 30 minutes per ticket. My question is, is there a way to create a formula or function to track both the minimum bill vs theDelay in rendering Zoho Recruit - Careers in the ZappyWorks
I click on the Careers link (https://zappyworks.zohorecruit.com/jobs/Careers) on the ZappyWorks website expecting to see the job openings. The site redirects me to Zoho Recruit, but after the redirect, the page just stays blank for several seconds. I'mHow to add interviews through API
I'm trying to add an interview without much luck. The documentation gives examples of adding just about everything except an interview. However, the issue might be the way I'm formatting it, because the documentation is unclear to me. It seems as if the xml should be passed in the url, which seems unusual. I've tried the data as both plain and character escaped, but nothing seems to work, nor do I even get an error response. https://recruit.zoho.com/recruit/private/xml/Interviews/addRecords?authtoken=***&scope=recruitapi&version=2&xmlData=<Interviews> <rowOffer already made- but I withdrew it
I made an offer letter, but made a mistake on it. I withdrew the offer but now I can't recreate the correct offer. Zoho keeps saying that "A same offer has already been made". I look in the "offers" and there are NO offers (this is the first time I'veControl the precision of answer bot responses
Hello everyone, Admins can control the precision with which the Answer bot analyzes and generates a response by adjusting the threshold levels. Based on predefined threshold values, Zia analyzes how closely the query matches with the available KB articles.Rebrand your CRM with the all-new custom domain mapping setup
UPDATES TO THIS FEATURE! 19th Jan, 2024 — Custom domain mapping has been made available for portal users in Zoho One and CRM Plus. 23rd June, 2023 — Custom domain mapping has been made available for all users, in all DCs. Hello everyone! We are elatedAdd Israel & Jewish Holidays to Zoho People Holidays Gallery
Greetings, We hope you are doing well. We are writing to request an enhancement to the Holidays Gallery in Zoho People. Currently, there are several holidays available, but none for Israel and none for Jewish holidays (which are not necessarily the sameSender Email ID is duplicate
My sender id "automate@erplaunchpad.com" is coming as duplicate but I have not used it anywhere else please helpCRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive
Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage filesBuilding Toppings #6 - Install and uninstall actions
Hello Biginners! In our previous forum post, we explored creating connections - specifically, custom service connections in the Bigin Developer Console. In this post, we'll focus on another feature that can be used in every topping: install actions. We'llNew UI in Zoho One CRM
Hello, Just switched to the new UI for Zoho One CRM, do not like it, especially the search functions. What are the steps to backstep to the previous UI? UPDATE: I found it.App like Miro
Hi all, is there a way to have a interactive whiteboard like in Miro? We want to visualize our processes and workflows in an easy way.Important updates to your connectors
Hello everyone, Greeting from Zoho Creator! We're excited to announce that we'll be rolling out significant backend updates to Zoho Creator's built-in connectors to enhance security by following the latest frameworks. The existing version of some of theHow Do Mutliple Sales People Prospect in the "LEADS" module without calling the same leads?
We have 4 sales reps and the Leads module does not have real time intuitive knowlodge to make the sales rteps dont call the same people at the same time. How can we crate a fluent prospecting sytem where the salres reps can go out bound without callingKeeping track of project expenses
I have talked to a few support techs and it is very hard for me to believe that Zoho's project accounting software can't keep accounts for my projects. I must not understand what they're saying. We get a contract to build something. So the project revenueMailbox delegation - A secure way to enable collaboration
Admins often encounter scenarios where a user needs another team member to access and manage their mailbox during extended leave, role transitions, or while handling high email volumes. In such situations, ensuring business continuity without sharingCanvas View bug
I would like to report a bug. When clone a canvas view from an existing canvas view, if the original canvas view have canvas button with client script. Then the new create canvas view will have canvas button, it is make sense. But when I try to deleteExport blueprint as a high-resolution PDF or image file
This would be a good feature for organizations that want to share the blueprint process with their employees but don't want them to have access to the blueprint in the system settings. At the moment all that users can do is screenshot the blueprint orZoho Recruit Community Meetup - London 🇬🇧 (Venue Finalised)
Hello Recruiters! We’re excited to announce that the Zoho Recruit team is coming to the UK for an in-person Zoho User Group (ZUG) Meetup in London! This is your chance to connect with fellow Zoho users, learn from experts, and walk away with actionableUsers may not pick the fields to be shown as columns in the Choose Account window when creating a new Deal record
Hi there, by talking with other users I found out that I, as an Admin, am the only one who can pick fields to be shown as columns in the Choose Account window when creating a new Deal record. In fact, if other users click on the "Add Column" symbol on【参加無料】東京 Zoho ユーザ交流会 NEXUS ー AI エージェント (Zia Agents)の活用事例 / CRMで実現するマーケティング業務効率化
ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 3月27日(金)に東京、新橋で「東京 Zoho ユーザー交流会 NEXUS」を開催します！ ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー ✒️申し込みはこちらから：https://www.zohomeetups.com/tokyo2026vol1#/?affl=communityforumpost2 ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー ★参加のおすすめポイント ✅ AIエージェント（Zia）のリアルに使える実例を知るError AS101 when adding new email alias
Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.ZOHO.CRM.UI.Record.open not working properly
I have a Zoho CRM Widget and in it I have a block where it will open the blocks Meeting like below block.addEventListener("click", () => { ZOHO.CRM.UI.Record.open({ Entity: "Events", RecordID: meeting.id }).catch(err => { console.error("Open record failed:",Python - code studio
Hi, I see the code studio is "coming soon". We have some files that will require some more complex transformation, is this feature far off? It appears to have been released in Zoho Analytics already🚀 WorkDrive 6.0 (Phase 1): Empowering Teams with Content Intelligence, Automation, Accessibility, and Control
Hello, everyone! WorkDrive continues to evolve from a robust file management solution into an intelligent, secure, and connected content collaboration platform for modern businesses. Our goal remains unchanged: to simplify teamwork, strengthen data security,Introducing Workqueue: your all-in-one view to manage daily work
Hello all, We’re excited to introduce a major productivity boost to your CRM experience: Workqueue, a dynamic, all-in-one workspace that brings every important sales activity, approval, and follow-up right to your fingertips. What is Workqueue? SalesNext Page