Does anyone know a way that I can get data to populate from multiple drop down list that are dependent on each other. Here is an example of what I am trying to do.
Drop down list
Fruit-->Apple, Banana, Orange
Vegetable--> Carrot, Potato
Data Set:
A B C
1 Food Group Food Type qty
2 Fruit Apple 1
3 Vegetable Carrot 3
4 Fruit Orange 1
5 Fruit Apple 3
6 Vegetable Potato 1
Now I need it to populate data from this list from a multiple dependent drop down list. The end result would look like this:
Fruit-->Apple -->qty
A B C
1 Food Group Food Type qty
2 Fruit Apple 1
3 Fruit Apple 3
4
Thank you for taking the time to help.
-J
Bookmarks