DropDowns

Drop-downs are simple lists of values. For example, we have a Logging Profile which includes the following tables:

Project

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

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

The table Project has two fields: Project and Description. The field Project is the Primary Key and the data values in this field are the drop-down values we will use:

Collar

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

The DropDown relationship is defined as follows:

Parent Table	The Reference Data table containing DropDown values.
Display Column	The field in the Reference Data table whose values are selected and displayed in the DropDown 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 DropDown List attached (displayed when you edit the table).