My scenario in a nutshell:
Theres a list which contains some food for example. (2010 Server)
Foods
ID Name
1 Apple
2 Banana
3 Carrot
4 Potato
Theres another list which contain food categories
Categories
ID Name MultiLookup_for_foods
1 Fruits 1;2
2 Vegeatables 3;4
Then theres the main list. It contains a multilookup field for Foods
I don't know how to achieve to create an InfoPath form, or a Designer workflow for the following scenario: I can select Categories, then the list should contain all the Foods in the selected Categories.
Any idea how to do it? I don't have Visual Studio so I'm stuck with InfoPath and SharePoint Designer