Skip to main content
A lookup field shows a value from a linked record. For example, display a customer’s email beside each order. Update the email in Customers, and the lookup reflects the change.

Before you start

Add a Link to table field and select the related records. For an order’s customer email, the order must already link to the right customer.

Add a lookup

  1. In the table where you want to show the value, select Add field → Lookup.
  2. Enter a Title, such as Customer email.
  3. Under Relations, select your linked-record field, such as Customer.
  4. Under Field to lookup, choose the source field, such as Email.
  5. Select Create.
Lookup field settings showing Customer as Relations and Email as Field to lookup.

Choose the relationship first, then the value you want to display.

Common uses

  • Orders: Show the linked customer’s email or delivery address.
  • Projects: Show the linked client’s account manager.
  • Inventory: Show a product’s supplier details on purchase orders.
A lookup can show values from multiple linked records. To combine those values into one total, count, or average, use a Rollup.

Look up a value through another lookup

A lookup can use another lookup as its source. For example, Orders links to Projects, and Projects has a lookup that shows each project’s client email. In Orders, add a lookup, choose Project under Relations, then choose the client email lookup under Field to lookup. You don’t need to link Orders to Clients directly.
  • You can chain lookups up to 10 levels.
  • A lookup can’t depend on itself. Zite stops you saving a chain that loops back to the field you’re editing.

If the result is blank or wrong

  • No linked record: Select a record in the Link to table field first.
  • Empty source: Check that the chosen field has a value in the linked table.
  • Wrong value: Check both the selected relationship and the field being looked up.
  • Blank through another lookup: Lookup values are saved, like formulas, rather than worked out fresh every time you open the table. A lookup that uses another lookup as its source can stay blank or out of date even if the lookup in the middle table looks correct. Selecting Refresh data reloads what is already saved. It does not recalculate lookup values. To refresh a stale value, edit the linked record in the middle table (for example, clear the link and choose the same record again), then open the outer table. You can also open the lookup field, point it at a different source, save, then point it back at the original source.
A lookup follows existing links. It doesn’t search another table for matching text or create links automatically. Edit the original value in the source table when it needs to change.
Last modified on November 13, 2026