Dynamic Filtering on a dropdown list.
I have a 3 tables.
Table 1 = Data from the app Table 2 = List of items (say 20 items) Table 3 = List of characteristics (say 50 characteristics) My data input form comes from table 1 It has three columns Column 1 = Unique ID (which is a concatenation of Item + Characteristic) Column 2 = Item (ref to table 2) Column 3 = Characteristic (ref from table 3)
The goal is to have the users fill in all the data over time i.e., Item + Characteristics such that each Item will have 50 characteristics.
I want to have the app ONLY show the unused characteristics.
Item = Car, Characteristics = Check point 1 to 49.
If Car + Characteristic 1 has been entered previously, I want the dropdown to only show Characteristics 2 to 49 for Car.
Do I have to create a list of 1000 answers (20 items
- 50 characteristics) or is there a smarter?