A lookup field is a database field that links a record to another table and displays related data. It typically stores a reference to the source record, while showing a readable value such as a customer name. Unlike copied text, the displayed value can stay aligned with the linked source data.
Lookup Field
What is a lookup field?
A lookup field is a database field that links one record to another and displays related data. A support ticket, for example, can store a customer record ID while showing the customer’s name or email.
How a lookup field works
A lookup usually follows these steps.
- Create a source table, such as Customers.
- Create a related table, such as Support Tickets.
- Save a reference to the selected customer record.
- Choose which source value to display.
- Update the source record when needed. Whether the displayed value refreshes automatically depends on the platform.
Lookup field vs. lookup table vs. rollup field
These related features solve different data problems.
| Feature | Purpose | Example |
|---|---|---|
| Lookup field | Shows data from a linked record | Ticket shows customer name |
| Lookup table | Stores approved reference values | List of product categories |
| Rollup field | Summarizes linked records | Customer’s total orders |
Benefits of lookup fields
They keep related application data easier to manage.
- Reduce duplicate data entry.
- Support more consistent forms and reports.
- Reuse the same relationship across screens.
Practical limitations of lookup fields
Good lookup design depends on reliable data.
- Deleted records can leave broken references.
- Matching on names can create ambiguity, so use stable unique IDs.
- Permissions may prevent users from viewing linked data.
- Large relationship queries can affect performance.
Lookup fields in Airtable, Access, Salesforce, and Excel
Terminology varies by tool.
| Platform | Approach |
|---|---|
| Airtable | Uses linked records and lookup fields. |
| Access | Offers a Lookup Wizard for selecting values. |
| Salesforce | Uses lookup relationships between objects. |
| Excel | Uses formulas such as XLOOKUP, not relational fields. |
Using lookup fields in an Emergent app
Emergent can help build apps with connected customers, orders, and tickets. Pair a lookup field with a rollup field or calculated field to present related data clearly without manually duplicating it.
Frequently Asked Questions
Your Questions, Answered
This will automatically populate, don't change
Don't change this element unless you know what you are doing
How do you add a lookup field in Access?
Open the table in Design View, select a field, then use the Lookup Wizard in the Data Type list. Choose whether values come from another table or a fixed list, and ensure the underlying relationship uses a unique key.
How do you create a lookup field in Salesforce?
In Object Manager, choose the object, open Fields and Relationships, select New, then choose Lookup Relationship. Select the related object, configure the field label and visibility, then save.
What are lookup fields in Airtable?
An Airtable lookup field displays a value from records connected through a linked-record field. For example, an Orders table can show a customer email stored in a linked Customers table.
What is the difference between a join and a lookup?
A join is a query operation that combines rows from tables for a result set. A lookup is usually a field or interface feature that follows a saved relationship to show related data.
How do you create a lookup in Excel?
Create a reference table with a unique key, then use XLOOKUP to return a matching value. For example, XLOOKUP can find a product ID in one table and return its product name from another.
Start Building
on Emergent today
on Emergent today
Start Building
