You can associate list box columns with fields from the master table and/or fields from different tables. For more information about the master table, refer to List box specific properties.
However, in all cases, the contents of the list box will be based on the current selection (or a named selection) of the master table of the list box:
- If you only use fields from the master table, the contents of the list box rows will simply be modelled on those of the master table selection.
- If you use fields that do not belong to the master table, these “foreign” tables must be related to the master table by a Many-to-One relation, otherwise the “foreign” fields will be displayed empty. Automatic relations will be activated for each record of the master table selection and the list box will display the corresponding data in the related fields.
If you use manual relations, you must program the activation of the relations in order to display the data in the list box.
If an inconsistency in the definition of the list box causes columns to be displayed empty, an error message will appear in the Application mode in each incorrect column.
We will use an example to explain the different cases.
Given a database with two tables: [Companies] and [Employees].
- The current selection for the [Companies] table is the following:
Company Name |
Big Encyclopedias |
Tiny Computers |
Boring Travel Company |
- The current selection for the [Employees] table is the following:
First Name | Last Name | Company Name |
Carla | Packard | Boring Travel Company |
Andrew | Black | Tiny Computers |
Vincent | Laughter | Boring Travel Company |
Oliver | Dawson | Boring Travel Company |
Sylvia | Fairview | Tiny Computers |
Robert | Lanzel | Big Encyclopedias |
Arnold | Schmitt | Boring Travel Company |
Elizabeth | Jones | Big Encyclopedias |
Yolanda | Court | Tiny Computers |
Pascal | Pratt | Tiny Computers |
The [Companies]Name field is associated with the first column of a list box. The [Employees]First Name and [Employees]Last Name fields are associated with the next two columns. The data source of the list box is the current selection.
- Case 1: The two tables are related using an automatic relation
1) The master table of the list box is [Employees]. The list box displays the current selection of the [Employees] table and activates the automatic relation to display the name of the company for each employee:
2) The master table chosen for the list box is [Companies]. The list box displays the current selection of the [Companies] table. Since there are only three records in this selection, only three rows are displayed in the list box. The columns for the [Employees]First Name and [Employees]Last Name fields are empty:
- Case 2: The two tables are not related (or they are related using a manual relation).
1) The master table of the list box is [Employees]. The list box displays the current selection of the [Employees] table. The column of the [Companies]Name field is empty:
2) The master table chosen for the list box is [Companies]. The list box displays the current selection of the [Companies] table. Since there are only three records in this selection, only three rows are displayed in the list box. The columns for the [Employees]First Name and [Employees]Last Name fields are empty:
Naturally, you can manage the selections of different tables by programming and in this way display columns associated with fields that do not belong to the master table.