Multiple Dynamic Dropdowns
I would like to create a nested set of dynamic dropdowns in order to select an output from a given table such that it would be:
Make>Model>Size>Thickness and lead to two outputs
I currently have a DIMENSIONS table that has all 6 data points, and would like to select it to OUTPUTS on a separate table and layout for other calculations.
They are currently related by Make, Model, Size, and Thickness, though I am unable to make it work this way or with just "Make" as the relationship. I can get "Model" to only work off from the selected "Make," but cannot get Size to limit based from both Model and Make.
How would I go about doing this?
I'd like to be able to select, for instance: A, a, 1, 6 and get 12 and 102. but not physically be able to select A,c,1,7.
Here is a sample table:
Actual options:2 makes, 3 models (same for both makes), 6 or 7 sizes for eachcombo, 5-7 thicknesses for each combo of the previous: TOTAL, ~300 options