database structure for drop down options in form
Posted: Wed Jul 10, 2013 6:43 am
Hi
I want to build a form with drop down lists of car makes and models
The first option will be make of car and the second will be the model of the car.
I will pull the information in from a database to fill in the second option dependent on the make of car.
Does anyone know the best structure of table to create this?
Would it be best to use 2 different tables? One for makes of cars and one for all models of cars? and have them connect dependent on the id of the make of car in the makes table?
I want to build a form with drop down lists of car makes and models
The first option will be make of car and the second will be the model of the car.
I will pull the information in from a database to fill in the second option dependent on the make of car.
Does anyone know the best structure of table to create this?
Would it be best to use 2 different tables? One for makes of cars and one for all models of cars? and have them connect dependent on the id of the make of car in the makes table?