Dependent Lists

In the list that should be dependent on another, ensure that the SQL query returns a column named exactly as the column that the list is dependent on.

In the example below, the UNIT listbox is dependent on the DIVISION column:

In yellow, the SQL query for the UNIT column, in the Test SQL window you can see that the query returns a column named DIVISION, which corresponds to the column in the gridform.

When a user selects something in the DIVISION list and then goes to the UNIT list, only UNITs linked to selected DIVISION will be returned.