{"id":5119,"date":"2026-05-30T02:40:45","date_gmt":"2026-05-30T02:40:45","guid":{"rendered":"https:\/\/aaxonix.com\/resources\/?post_type=glossary&#038;p=5119"},"modified":"2026-05-30T02:40:45","modified_gmt":"2026-05-30T02:40:45","slug":"lookup-field-zoho-creator","status":"publish","type":"glossary","link":"https:\/\/aaxonix.com\/resources\/glossary\/lookup-field-zoho-creator\/","title":{"rendered":"Lookup Field (Creator)"},"content":{"rendered":"<h2>What Is a Lookup Field in Zoho Creator?<\/h2>\n<p>A Lookup field in Zoho Creator creates a relationship between two forms, similar to a foreign key in a relational database. It allows a record in one form to reference a specific record in another form. For example, a Sales Order form might have a Lookup field pointing to the Customer form, linking each sales order to the customer who placed it.<\/p>\n<h2>Display and Search<\/h2>\n<p>When a user fills in a lookup field, they search for and select the related record from a popup list. The lookup field stores the ID of the referenced record and can display any field from that record (e.g., showing the customer name when storing the customer ID). Auto-complete makes finding related records fast.<\/p>\n<h2>Subforms via Lookup<\/h2>\n<p>Multiple records in Form B can point to the same record in Form A, creating a one-to-many relationship (e.g., multiple Sales Order Lines linking back to one Sales Order). Zoho Creator manages these relationships automatically and allows you to display related records as a grid within the parent record&#8217;s detail view.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A field in a Zoho Creator form that references a record from another form, creating a relational link between two data tables within the application.<\/p>\n","protected":false},"template":"","meta":{"seo_title":"Lookup Field (Creator) | Zoho Glossary | Aaxonix","seo_description":"A field in a Zoho Creator form that references a record from another form, creating a relational link between two data tables within the application.","seo_keyword":"lookup field zoho creator","seo_faqs":"","term_type":"","glossary_related":"","glossary_links":""},"glossary_category":[1258],"class_list":["post-5119","glossary","type-glossary","status-publish","hentry","glossary_category-zoho-creator"],"_links":{"self":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary\/5119","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=5119"}],"wp:term":[{"taxonomy":"glossary_category","embeddable":true,"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary_category?post=5119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}