Drop Down Menu with Different Values
I have a layout with one text box for "Category" Then I want to add a drop down menu for "Subcategory" in that same layout beside another text box for "Price". Now what I want is, whenever the user puts in the name of the category, he would be able to choose one subcategory and add the price to it. Then he chooses another subcategory and add the price to it in the same record. For example, The user types the category: Animals Then he chooses from the list of Subcategories: Fish Then he types the price of the fish: $ 10 Then he chooses from the list of subcategories again: Cat Then he types the price of the cat: $ 200 He would then add a new record: Plants . . . .... and so on. Is there anyway I could do that?