There are two types of lookups: 

  • List lookups provide a set list of predetermined values. List lookups display as drop down lists in an application.
  • Table lookups provide a way to search for a value from another record or table, and can even retrieve values from multiple fields in the selected record. Table lookups display as search fields in an application.

Use lookups to validate entries in fields in a variety of ways:

  • Provide only a set list of predetermined values.
  • Offer a subset of options based on the selection in a different lookup field.
  • Limit available choices to entries from another table.
  • Automatically update the value displayed for a field when the data in the related table changes.

How a lookup functions depends on its type and whether it is configured with any extended functionalities.

How to choose a lookup type

Use these suggestions to help you decide what type of lookup to use.

If you want to...Use a...
Provide a drop-down list of predetermined values

List lookup

Determine the options available in a drop-down list from the user's selection in another field

Dependent list lookup
Determine the subset of dependent list lookup options available in a drop-down list from a field dependency setting within Application Builder.
Filtered Dependent list lookup
Determine the options available in a list lookup based on the list lookup name a user enters in another field.
Dynamic list lookup

Determine valid selections from entries in another table, and list matching options when the user begins entering a value

Table lookup

Determine valid selections from entries in another table, and filter those options based on the user's selection in another field

Filtered table lookup

Make sure that the displayed value for a field always represents current data from the related table

Table lookup on a Table Lookup data item
Allow the user to search a related table for a value, but copy the value as static text that does not change over time even if the value in the source table changesTable lookup on a Text data item