We want to limit the options in a field "Sub-System" that the user will select from; based on the selection in the previous field "System".
The current setup; user selects the "System" (Architectural, Mech, Elec, Plumb, etc.). Then they select the "Sub-System" that corresponds to the System (exterior walls, roofs, windows, etc.),
either in "FCA_DATA" Table or Form.
We want the Sub-System list to be shortened to only show those Sub-systems that are connected to the Systems. The current list contains 114 Sub-Systems.
Architecture would only show 8 sub-systems, Mech only listing 12 sub-systems. We have a table [Systems], that lists all 15 Systems. We have another table [Sub-System] that lists the
a. (systems, connected to previous table), b. Sub-systems, c. Useful Life of sub-syst, d. notes
I am having a hard time trying to form the search question in Google to help me...
Thanks!!!!!!