A Multi-Lookup Field in Zoho CRM is a field type that creates a many-to-many relationship between two modules. Unlike a standard Lookup Field which links one record to one parent, a Multi-Lookup Field lets a single record be associated with multiple records from another module.
A standard Lookup Field creates a one-to-many relationship: one parent record linked to many child records. A Multi-Lookup Field creates a many-to-many relationship: one child record linked to many parent records, and each parent can have many children.
For example: a Contact can belong to multiple Accounts (useful for consultants who work across several companies), or a Product can be linked to multiple Deals. The Multi-Lookup Field enables this without creating separate junction records manually.
A Subform embeds a table of related records on the parent record’s layout. A Multi-Lookup Field appears as a tag-style selector where you pick multiple records from a search box. Subforms are better for line-item style data; Multi-Lookup is better for simple multi-association.
A Multi-Lookup Field in Zoho CRM is a field type that creates a many-to-many relationship between two modules. Unlike a standard Lookup Field which links one record to one parent, a Multi-Lookup Field lets a single record be associated with multiple records from another module.
A Lookup Field creates a one-to-many relationship – one parent linked to many children. A Multi-Lookup Field creates a many-to-many relationship – one record linked to multiple records in another module, and vice versa.
Aaxonix is a certified Zoho implementation partner based in Pune. Architecture-first, no surprises.