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
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 #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 areKaizen #152 - Client Script Support for the new Canvas Record Forms
Hello everyone! Have you ever wanted to trigger actions on click of a canvas button, icon, or text mandatory forms in Create/Edit and Clone Pages? Have you ever wanted to control how elements behave on the new Canvas Record Forms? This can be achievedKaizen #142: How to Navigate to Another Page in Zoho CRM using Client Script
Hello everyone! Welcome back to another exciting Kaizen post. In this post, let us see how you can you navigate to different Pages using Client Script. In this Kaizen post, Need to Navigate to different Pages Client Script ZDKs related to navigation A.
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
How to manage task lists in Zoho Desk?
Hello, I use Zoho Desk for IT customer support. I have a list of standard operating procedures (SOPs), including SOPs for onboarding new users, offboarding users, losing a device, etc. These are lists of tasks to be performed depending on the situation.How to compare a subform lookup field that allows multiple entries when edited
I have a form with a subform with multiple fields. One of the fields is a lookup field that allows a multi select. On edit validation, I want a workflow to execute only when the entries in that subform field has changed. The old. function is not workingIs Zoho Shifts included in the Zoho One plan?
In case the answer is no: there's any plan to make it available via One? Thank youCreating a Chart from a Report
In Zoho Analytics, is it possible to create a chart from a Pivot View report? We are looking to use Zoho Analytics to replace Excel for Sales reports and would like to be able to show both the table and the chart together.No funcionan correctamente el calculo de las horas laborales para informe de tickets
Hola, estoy intentando sacar estadísticas de tiempo de primera respuesta y resolución en horario laboral de mis tickets, pero el calculo de horas en horario laboral no funciona correctamente cree los horarios con los feriados : Ajusté los acuerdos deZoho Tracking Image location
So we've been having an issue with tracking email opens. Specifically in Gmail. Our emails are not that long either, maybe 4 sections of image/250 characters of text/button per section. But all my test accounts I used via Gmail we're showing opens. But then come to find out the tracking image is at the very bottom of the email. So If the message is clipped (It always just clips our social icons on the bottom) and the user doesn't click the show more button it never tracks the open. Looking at otherZoho → ShipStation Integration – Sales Order–Driven Fulfilment Workflow
Hello All, I’m reaching out to explore the best way to integrate a shipping tool into our inventory which will speed our process up. We are looking to integrate ShipStation into our existing order-to-fulfilment workflow, as we’re keen to standardise onIs there a plan to integrate zoho voice with zoho books?
Hello, Is there a plan to integrate zoho voice with zoho books? Right now we are using the Twilio SMS integration into zoho books, but have recently decided to switch to zoho voice for calls and sms. Is there a plan to integrate zoho voice natively intoZoho Tables is now live in Australia & New Zealand!
Hey everyone! We’ve got some great news to share — Zoho Tables is now officially available in the Australian Data Center serving users across Australia and New Zealand regions! Yes, it took us a bit longer to get here, but this version of Zoho TablesIntroducing Dedicated Modules for Plans, Addons, and Coupons in Zoho Billing
We’ve enhanced the way you manage Plans, Addons, and Coupons in Zoho Billing. Previously, all three grouped together under Subscription Items. Now, each one has its own dedicated module, giving you a cleaner and more intuitive experience. This updateSortie de Zoho TABLE ??
Bonjour, Depuis bientôt 2 ans l'application zoho table est sortie en dehors de l'UE ? Depuis un an elle est annoncée en Europe Mais en vrai, c'est pour quand exactement ??Zoho Forms API
Is there any way to get all form entry list using API? Looking forward to hear from youAdding a new section to the related details sidebar when creating a new ticket.
Hello, I was wondering if you can add a new section to the related details sidebar when creating a new ticket. I was wanting to have it to where it also shows the account information related to the contact chosen as well. This is the section I am referringIssue with WhatsApp Template Approval and Marketing Message Limit in Zoho Bigin
We are facing issues while creating and using WhatsApp message templates through Zoho Bigin, and we request your clarification and support regarding the same. 1. Utility Template Approval Issue Until December, we were able to create WhatsApp templatesHow to install Widget in inventory module
Hi， I am trying to install a app into Sales Order Module related list, however there is no button allow me to do that. May I ask how to install widget to inventory module related list?Zoho Social - Feature Request - Reviewer Role
Hi Social Team, I've come across this with a couple of clients, where they need a role which can review and comment on posts but who has no access to create content. This is a kind of reviewer role. They just need to be able to see what content is scheduledZoho Social - Feature Request - Non-US Date Format
Hi Social Team, I have noticed that there is no option to change the date format from US mm/dd/yyyy to others like dd/mm/yyyy. It would be great to see this added as the platform matures. Thanks for considering this feedback.Drop Down Value
Hi, May I know why Zoho Flow treat this drop down as number and not as string. If so, how can I fetch the right value for filtering. This field is from Creator, in Creator upon checking by default it is a string since it's not a lookup field.Zoho CRM's mobile apps: A 2025 Recap
2025 marked a year of steady progress for Zoho CRM's mobile apps. We rolled out several updates and features to improve usability and make everyday CRM work a lot easier to manage. Here’s a look back at some of the key releases from 2025. Android releasesDependent / Dynamic DropDown in ZohoSheets
Has anyone figured out a way to create a Dropdown, the values of which is dependent on Values entered in the other cell ?Facebook follower count doesn't match FB Analytics
Hi all, I am wondering if anyone else has issues with follower counts for Facebook not matching FB's native analytics tool. On the Zoho dashboard, it's showing 1,007, but FB shows 1,060. All the other channels match up. Any insights are much appreciated!Unable to mass update a picklist field
Hello, I have the records within our Accounts module divided between two account types: Parent Accounts & Member Accounts. I am attempting to mass update accounts from one picklist value to the other (within other specific criteria in our custom fields)Meta and Facebook data report discrepancy
I have been currently gathering manually facebook follower data thru meta. In zoho marketing plus the social media reporting only allows for page likes, and so there is a discrepancy with the data. please the difference in files attached. Is there wayBusiness Day Logic Update: More Accurate Scheduling for Your Workflows
Hello everyone, We’re improving how business-day calculations work in workflows, especially when triggers happen on weekends. This update ensures that offsets like +0, +1, and +2 business days behave exactly as intended, giving you clearer and more predictableDevelop and publish a Zoho Recruit extension on the marketplace
Hi, I'd like to develop a new extension for Zoho Recruit. I've started to use Zoho Developers creating a Zoho CRM extension. But when I try to create a new extension here https://sigma.zoho.com/workspace/testtesttestest/apps/new I d'ont see the option of Zoho Recruit (only CRM, Desk, Projects...). I do see extensions for Zoho Recruit in the marketplace. How would I go about to create one if the option is not available in sigma ? Cheers, Rémi.Unlocking New Levels: Zoho Payroll's Journey in 2025
Every year brings its own set of challenges and opportunities to rethink how payroll works across regulations and teams. In 2025, Zoho Payroll continued to evolve with one clear focus: giving businesses more flexibility, clarity, and control as they grow.Can I export all attachments from Zoho CRM?
Can I export all attachments from Zoho CRM?Please can the open tasks be shown in each customer account at the top.
Hi there This has happened before, where the open tasks are no longer visible at the top of the page for each customer in the CRM. They have gone missing previously and were reinstated when I asked so I think it's just after an update that this featureWhat's new in Zoho Sheet: Simplify data entry and collaboration
Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementallyDisplaying only unread tickets in ticket view
Hello, I was wondering if someone might be able to help me with this one. We use filters to display our ticket list, typically using a saved filter which displays the tickets which are overdue or due today. What I'd really like is another filter thatCommunity Digest — Noviembre y Diciembre 2025
¡Hola, Comunidad de Zoho en Español! Cerramos el año de la mejor forma con nuestro último Community Digest de 2025, donde podrás encontrar las últimas novedades de nuestros productos. ¿Todo listo para empezar 2026 con el mejor pie? ¡Vamos a ello! ZohoPassing the CRM
Hi, I am hoping someone can help. I have a zoho form that has a CRM lookup field. I was hoping to send this to my publicly to clients via a text message and the form then attaches the signed form back to the custom module. This work absolutely fine whenZoho Projects Plus’ 2025- the year we launched
We’ve been building project management tools for the past 19 years, and a question we often hear is: Different teams in our organization prefer different project management methods; while the development team prefers agile, the marketing and sales teamsWhy can't we change the Account type from an Expense to an Asset?
Like the question. Why in QuickBooks for example if I mistakenly created an account as an expenses and I already captured information in those accounts, I can just change the account type from expense to assetMove email between inboxes?
Is it possible to move emails from one team inbox to another? We would like to be able to have a single "catch-all" inbox for incoming requests, and then move the email to the appropriate department inbox. I was hoping we would be able to accomplish thisZoho Books emails suddenly going to Spam since 11 Nov 2025 (Gmail + now Outlook) — anyone else?
Hi everyone, We migrated to Zoho Books in July 2025 and everything worked fine until 11 Nov 2025. Since then, Zoho Books system emails are landing in customers’ Spam (first Gmail, and now we’re seeing Outlook/Office 365 also starting to spam them). ImpactedDefault Tagging on API-generated Transactions
If one assigns tags to an Item or Customer, those tags get auto-populated in each line item of an Invoice or Sales Order when one creates those documents. However, if one creates the Sales Order or Invoice via the API (either directly coding or usingHow do you print a refund check to customer?
Maybe this is a dumb question, but how does anyone print a refund check to a customer? We cant find anywhere to either just print a check and pick a customer, or where to do so from a credit note.Data Import | Zoho Analytics Custom Query Window Size
Please increase the window size for the Custom Query Data Import. It's impossible to work with such a small query window.Company Multiple Branch/ Location Accounting
Hi All, anyone know whether company can maintain their multiple Branch Accounting in Zoho Books. It will be chart of Accounts & Master Data will be same but different report available as per per Branch. Thanks & regards, Vivek +91 9766906737Next Page