Skip to content

Lookup Lists

Set Field_Prompt_Object field Customer.name to Cust_lkup

Lookup lists are created to provide an easy way to look up records in your application. Typically, each table will have at least one lookup list associated with it. Columns in this lookup list will often consist of the most important fields in your table. These fields are often indexed, and lookup lists are designed to let you easily search for records in any of these index orders.

You assign fields in a Data Dictionary to a lookup by setting the Field_Prompt_Object property. Once assigned, your Windows applications will automatically attach those lookup lists to data entry objects that use that field.

You will want to create your lookup list objects before you assign them to a Field_Prompt_Object. You must know the name of the lookup list object before you assign it. Wizards are provided that allow you to create your lookup lists and assign them to the appropriate Data Dictionary fields in a single step.

If you are using one of the validation types (checkbox, range, check, or validation table), the Data Dictionary is smart enough to provide a default prompt list. It does this if there is no prompt list explicitly assigned. So, if you assign a Field_Prompt_Object for a field, it will be used in place of the prompt list provided for extended validations.

See Also