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 changes | Table lookup on a Text data item |