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:

Gridform_design_dependent_list

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.
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:

Gridform_design_dependent_list

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.
For an optimal Community experience, Please view on Desktop
Powered by Zendesk