3 Replies Latest reply on Nov 5, 2012 9:04 AM by Th10

    Multiple Dynamic Dropdowns

    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!!