Attached is the problem file:
What it shows:
In the layout called "Worksheet Simple"
You can select the Ceiling Type.
This drop-down list is generated from existing values in the Layout called "4A Ceilings" via a relationship.
This works correctly.
Now the second menu:
You can select the "Insulation" type.
This list is generated in the exact same manner as the drop down list above, however, it shows ALL values. Not the ones valid for the ceiling type selected in the first menu.
Since it is Matching the value the user selected from the first menu to the Table in 4A, it shouldn't show ALL values, just the ones that are related... shouldn't it?
What it shows:
In the layout called "Worksheet Simple"
You can select the Ceiling Type.
This drop-down list is generated from existing values in the Layout called "4A Ceilings" via a relationship.
This works correctly.
Now the second menu:
You can select the "Insulation" type.
This list is generated in the exact same manner as the drop down list above, however, it shows ALL values. Not the ones valid for the ceiling type selected in the first menu.
Since it is Matching the value the user selected from the first menu to the Table in 4A, it shouldn't show ALL values, just the ones that are related... shouldn't it?
