Dependent dropdown, with data arranged in columns

  • I have frequently used the "indirect" method for creating a second, dependent dropdown. This seems to require that the data are arranged like this with 1st level categories in the first row and the 2nd choices in the column below it.
    [TABLE="border: 1, cellpadding: 1, width: 500"]

    [tr]


    [td]

    Fruits

    [/td]


    [td]

    Vegetables

    [/td]


    [td]

    Other

    [/td]


    [/tr]


    [tr]


    [td]

    Apples

    [/td]


    [td]

    Carrot

    [/td]


    [td]

    Meat

    [/td]


    [/tr]


    [tr]


    [td]

    Oranges

    [/td]


    [td]

    Potato

    [/td]


    [td]

    Bread

    [/td]


    [/tr]


    [tr]


    [td]

    Bananas

    [/td]


    [td][/td]


    [td]

    Pizza

    [/td]


    [/tr]


    [/TABLE]

    This is all fine if you do not have many 1st level categories, but I have like +100 of these and currently my data is arranged like this. I will also have items that are present in more than one category
    [TABLE="border: 1, cellpadding: 1, width: 500"]

    [tr]


    [td]

    Fruits

    [/td]


    [td]

    Apples

    [/td]


    [/tr]


    [tr]


    [td]

    Fruits

    [/td]


    [td]

    Oranges

    [/td]


    [/tr]


    [tr]


    [td]

    Fruits

    [/td]


    [td]

    Bananas

    [/td]


    [/tr]


    [tr]


    [td]

    Vegetables

    [/td]


    [td]

    Carrot

    [/td]


    [/tr]


    [tr]


    [td]

    Vegetables

    [/td]


    [td]

    Potato

    [/td]


    [/tr]


    [tr]


    [td]

    Other

    [/td]


    [td]

    Meat

    [/td]


    [/tr]


    [tr]


    [td]

    Other

    [/td]


    [td]

    Bread

    [/td]


    [/tr]


    [tr]


    [td]

    Other

    [/td]


    [td]

    Pizza

    [/td]


    [/tr]


    [tr]


    [td]

    Round fruits

    [/td]


    [td]

    Apples

    [/td]


    [/tr]


    [tr]


    [td]

    Round fruits

    [/td]


    [td]

    Oranges

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]


    This is an example. My true data source is an AAO Query with bills of materials from SAP for several materials.. So column 1 is the material. Column 2 is the components used in the given material and then there's a 3rd column with the quantity for each component per material. That's also why it's not trivial (to not say impossible) to just arrange the data as shown in the first table.


    I need to provide the user with an easy way to select with an in cell drop down:


    1) The desired material
    2) in the cell next to it a list of components assigned to that material


    Finally I can with lookup find the quantiy of the component for the material.


    Putting it all in a standard table and just use filtering would not work as I need a lot of other stuff going on in the user interface part.


    Any good ideas?

  • I've made up a dummy example
    The ribbon will show the assemblies available > click on an item in the Tree and then click add assemble button
    After adding a few assemblies > right click and use the context menu > top selection to generate the bill of materials

  • I've made up a dummy example
    The ribbon will show the assemblies available > click on an item in the Tree and then click add assemble button
    After adding a few assemblies > right click and use the context menu > top selection to generate the bill of materials


    Hi pike :-)


    Thanks a lot for your efford, but I'm afraid it's waaaay too advanced.


    I might not have been totally clear or I have not understood the suggested solution. Sorry :-)


    I (and especially the users) will need two cells in a row. First cell you select from the list of materials (e.g. fruits/Vegetables/Other/Round fruits etc). The second cells drop down will then populate with the list of components that is within the selected material (e.g. select Fruits in cell 1 and cell 2 will the let you select between apple, orange and banana).


    I hope it make sense