Show/Hide Toolbars

Lookup tables store and list items for users to select. Depending on the system settings and an individual user's Preference settings, lookup tables can be displayed in the following types of fields:

Drop-down list (most common)

Option (radio) buttons

Lookup Table Display Example of a Drop-Down List

Lookup Table Display Example of a Drop-Down List

Lookup Table Display Example of Option Buttons

Lookup Table Display Example of Option Buttons

System lookup tables contain a set of default items. For example, the Address Type lookup table has three items: Home, Business, and Other. You can add to, edit, inactivate, or delete them to fit your design.

You cannot create new system lookup tables. However, you can create custom lookup tables that are specific to your organization. For details, see Creating Custom Pages.