A Multi-Lookup field in Zoho Creator is an extended lookup that allows one record to reference multiple records in another form simultaneously. While a standard Lookup field creates a many-to-one relationship, a Multi-Lookup creates a many-to-many relationship. For example, a project record can be linked to multiple team member records, and each team member can be linked to multiple projects.
On the form, a Multi-Lookup renders as a search and select component where users can pick multiple values from the linked form’s records. Selected values are displayed as tags or a comma-separated list. In Deluge, the field value is accessed as a list, allowing the script to iterate over all linked records and process each one individually.
A Multi-Lookup is appropriate when the relationship is between two existing record types and no additional attributes need to be stored on the relationship itself. A Subform is appropriate when each related record needs its own set of fields, such as line items on an order where each item has a quantity and price. If the relationship itself carries data, use a Subform; if you just need to link records together, use a Multi-Lookup.
Aaxonix is a certified Zoho implementation partner based in Pune. Architecture-first, no surprises.