AnsweredAssumed Answered

Multiple Dynamic Dropdowns

Question asked by Th10 on Nov 1, 2012
Latest reply on Nov 5, 2012 by Th10

Title

Multiple Dynamic Dropdowns

Post

     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:

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
                    Make                     Model                     Size                      Thickness                     OutA                     OutB
                    A                     a                     1                     5                     11                     101
                    A                     a                     1                     6                     12                     102
                    A                     a                     1                     7                     13                     103
                    A                     a                     2                     5                     14                     104
                    A                     a                     2                     6                     15                     105
                    A                     b                     1                     7                     16                     106
                    A                     b                     2                     6                     17                     107
                    A                     c                     1                     5                     18                     108
                    A                     c                     2                     6                     19                     109
                    B                     a                     1                     5                     20                     110
                    B                     a                     2                     6                     21                     111
                    B                     b                     1                     5                     22                     112
                    B                     b                     3                     7                     23                     113
                    B                     b                     3                     8                     24                     114
                    B                     c                     1                     1                     25                     115
                    B                     c                     2                     2                     26                     116

     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

     THANK YOU!!

Outcomes