Lookup fields in Zoho CRM let you display data from a related record directly on another module's layout, eliminating the need to jump between records to find relevant information. Here's everything you need to know to add and work with them effectively — from Beam Help, your independent expert support for Zoho (not official Zoho support).
Why this matters
When your team needs to see, for example, an Account's billing city right on a Deal record, a lookup field surfaces that data automatically without any manual copy-paste. Because the field stays in sync with its source, any update to the linked record is reflected everywhere the lookup field appears. [1] This is especially valuable for reporting, filtering, and building custom views that span related modules.
Step-by-step
Step 1. Understand what a lookup field does before you build one.
A lookup field reads and mirrors the value of a field from a linked (related) record. It is always read-only — you cannot edit the value directly on the record that contains the lookup field; changes must be made on the source record. [1] Once the source record is updated, the lookup field updates automatically across every record it appears on. [1]
Step 2. Navigate to the module layout editor.
In Zoho CRM, go to Setup → Customization → Modules and Fields, then select the module where you want the lookup field to appear (for example, Deals). Open the layout you want to edit.
Step 3. Add the lookup field to the layout.
From the field panel on the left, locate the Lookup field type and drag it onto the layout canvas. You will be prompted to configure which related module and which specific field value you want to display. [1]
Step 4. Configure the related module and source field.
Select the module you want to pull data from (for example, Contacts or Accounts) and then choose the specific field within that module whose value should be mirrored. You can add multiple lookup fields on the same layout if you need to surface data from several related records at once. [1]
Step 5. (Optional) Set up a dynamic lookup filter.
If you want to narrow down which records appear in the lookup dropdown during data entry, configure a lookup filter. Zoho CRM's dynamic lookup filters adapt in real time based on the field values already present in the current module — so the list of selectable records changes depending on what the user has already filled in. [4] This reduces selection errors and speeds up data entry significantly. [4]
Step 6. Use the lookup field in queries (advanced).
If your team uses the Queries tool under Setup → Developer Hub → Queries, you can include lookup fields in your query configuration. When building a query for a module that has lookup fields, select the related module from the Related Module drop-down — note that a maximum of two lookup-related modules can be included per query. [7] You can then pull up to 50 fields total from the primary and related modules in a single query. [7]
Step 7. Leverage the lookup field like any other field.
Once added, the lookup field behaves like a standard field throughout Zoho CRM. You can build filters, sort records, and create custom views based on its value — making it a powerful tool for segmenting and reporting on your data. [1]
Common pitfalls
- Trying to edit the lookup field directly. Because it mirrors a source record, the lookup field is strictly read-only. [1] If users need to change the value, they must navigate to the linked record and update it there.
- Expecting a custom display field in the lookup dropdown. Unlike Zoho Creator, Zoho CRM's lookup dropdowns currently show only the default display field when selecting a related record. [2] If your team finds it hard to identify the right record from the dropdown, consider adding a lookup filter (Step 5) to reduce the list to the most relevant options. [4]
- Exceeding query limits. When using lookup fields inside the Queries tool, remember the cap of two related modules and 50 total fields per query. [7] Exceeding these limits will prevent the query from saving.
- Multi-select lookup fields require a different API approach. If you are working with multi-select lookup fields (M×N relationships) via the Zoho CRM API, there are two distinct methods: inserting records via the insert records API, or using the linking module approach. [3] Using the wrong method is a common source of integration errors.
What to check
- Sync is working: After saving the layout, update a value on the source (linked) record and confirm the lookup field on the related record reflects the change automatically. [1]
- Filters are scoping correctly: If you configured a dynamic lookup filter, test it by partially filling in the current record's fields and verifying that the lookup dropdown narrows its results as expected. [4]
- Queries return the right data: If you included the lookup field in a Developer Hub query, run a test execution and confirm the related module fields appear in the response and that the two-module limit has not been exceeded. [7]