Combo Box / List Box Wizard: Table Selection

Specifies a table from the available database tables that contains the data field whose content should be displayed as a list entry.

To access this command...

Open Form Controls toolbar, click Combo Box or List Box icon and drag mouse to generate field. Database connection must exist in the form: Wizard - Page 1.

For list boxes, a table that can be linked with the current form table is indicated. The link table must have at least one field in common with the table of the current form. This makes it possible to establish an unambiguous reference.

For combo boxes, there must be a relationship between the form table and the table containing the data to be displayed in the combo box.

Table

In the Table field, select the table containing the data field whose content should be displayed in the control field.

The table given here appears in the Control properties as an element of an SQL statement in the List Contents field.