Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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:

The query returns a column named DIVISION, which corresponds to the column in the gridform.

The gridform where the list is used:

Below is a preview of gridform. Note that the UNIT drop-down will not populate until the DIVISION is selected:

Once you select something in the DIVISION list, only UNITs linked to selected DIVISION will be returned, as shown below:
Published:

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:

The query returns a column named DIVISION, which corresponds to the column in the gridform.

The gridform where the list is used:

Below is a preview of gridform. Note that the UNIT drop-down will not populate until the DIVISION is selected:

Once you select something in the DIVISION list, only UNITs linked to selected DIVISION will be returned, as shown below:
For an optimal Community experience, Please view on Desktop
Powered by Zendesk