The contents of the system’s standard lookup forms are based on relations set up on the database table, and on the Extended Data Type. It consists of these components

• TitleField1 from the related table

• TitleField2 from the related table

• The fields making up the relation

If any of these are identical, the system automatically leaves out duplicates.

An example from the application: the Customer group field on the CustTable form

Clicking the lookup button on the Customer group field on the CustTable form’s General tab page give you a list like the following:

The lookup information is based on the relation on the CustGroupId Extended Data Type used for the CustGroup field.

TitleField1 and TitleField2 from the CustGroup table, the related table, are CustGroup and Name.

So the values in the first column are CustGroup field values, and the column heading is the CustGroup field label “Customer group” that is inherited from the Extended Data Type.

The values in the second columns are Name field values, and the column heading is the Name field label “Description”, also inherited from the Extended Data Type.

The third component, the related field, is omitted as it it identical to TitleField1.