Let's say you have an on-line computer store, and you are creating an administration page so your employees can add new products to the database.
This administration page is a form with several fields. There's a name of product field, a price field, a list of areas where the new product belongs:
And a list of sub areas:
Say that you are adding a new product using this administration and it is a game.
After filling in the name of the game and the price, you have to choose Software and Games in the areas list. Then only the sub areas related to the Software and Games areas should show:
for you to choose the right sub area or sub areas .
How can I do that?
I'm thinking in a multiple select for the areas, but then how can I show just the sub areas related to the areas chosen? and then these sub areas have to be able to be selected amd submitted with the rest of the form.
Also, how's the structure of the MySql table or tables? I still don't get how an area "understands" what is the sub area that belongs to it.
I'm lost, please help!!
Thanks in advance!