Lookups

Look-ups are similar to drop-downs, but instead of displaying a simple list of values, multiple columns may be displayed:

For example, we have a Logging Profile which includes the following tables:

LKPHoleStatus

The table LKPHoleStatus has been defined as a Reference Data table:

Any table used to provide a Lookup list must be of type Reference Data.

The table LKPHoleStatus has two fields: Code and Description. Code is the Primary Key and the data values in this field are the look-up values we will use:

Collar

The table Collar has several fields, including a field HoleStatus. This is the field we want to attach a Lookup List to:

The Lookup relationship is defined as follows:

Field	Description
Parent Table	The Reference Data table containing Lookup values.
Popup Table Columns	The fields in the Reference Data table that are displayed in the Lookup List.
Display Column	The field in the Reference Data table whose values are selected and displayed in the Lookup field.
Filter Expression	Click the ellipsis (...) button to enter a Filter Expression in the Filter Editor. The expression determines which filtered subset of records to display.
Header Background	The background colour for the header of the column with the Lookup List attached (displayed when you edit the table).