{"id":5163,"date":"2026-05-30T02:49:18","date_gmt":"2026-05-30T02:49:18","guid":{"rendered":"https:\/\/aaxonix.com\/resources\/?post_type=glossary&#038;p=5163"},"modified":"2026-05-30T02:49:18","modified_gmt":"2026-05-30T02:49:18","slug":"multi-lookup-zoho-creator","status":"publish","type":"glossary","link":"https:\/\/aaxonix.com\/resources\/glossary\/multi-lookup-zoho-creator\/","title":{"rendered":"Multi-Lookup (Creator)"},"content":{"rendered":"<h2>What Is a Multi-Lookup in Zoho Creator?<\/h2>\n<p>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.<\/p>\n<h2>How Multi-Lookup Works<\/h2>\n<p>On the form, a Multi-Lookup renders as a search and select component where users can pick multiple values from the linked form&#8217;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.<\/p>\n<h2>Multi-Lookup vs Subform<\/h2>\n<p>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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Multi-Lookup field in Zoho Creator allows a record to be linked to multiple records in another form, creating a many-to-many relationship.<\/p>\n","protected":false},"template":"","meta":{"seo_title":"Multi-Lookup (Creator) | Zoho Glossary | Aaxonix","seo_description":"A Multi-Lookup field in Zoho Creator allows a record to be linked to multiple records in another form, creating a many-to-many relationship.","seo_keyword":"Zoho Creator multi-lookup","seo_faqs":"","term_type":"","glossary_related":"","glossary_links":""},"glossary_category":[1258],"class_list":["post-5163","glossary","type-glossary","status-publish","hentry","glossary_category-zoho-creator"],"_links":{"self":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary\/5163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary"}],"about":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/types\/glossary"}],"wp:attachment":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/media?parent=5163"}],"wp:term":[{"taxonomy":"glossary_category","embeddable":true,"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary_category?post=5163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}