I would like to have a user select from one box on a form in progressive steps, to narrow down an exact product and save that product to a field.
Here is a sample of the table data (there will be around 100 items) the user will select from (dash for fields delimeter):
Tools - Hand Tools - 120 V - Drills - Makita - 1/2
Tools - Hand Tools - 9.5 V - Flashlight
Food - Perishable - Fruit - Apples - Macs
Food - Non-Perish - Cookies - ValuePak
Food - Non-Perish - Cookies - Ginger
Condiments - Salt
Condiments - Sauce - Spicey
I would like the user to be able to select from 1 box, ie a popdown menu, the first step in the case above would allow for the options: Tools,Food, & Condiments only, then if Food is chosen, the options would change to Perishable & Non-Perish, then if selecting Non-Perish, the value options would change to Cookies, and then when selecting Ginger, since there are no further Cookie options, would set the desired field to "Food - Non-Perish - Cookies - Ginger"
What would be the best way to approach the above!
Thanks so much in advance!