Hi everyone I am new to PHP Magic and am trying to find a solution to a problem when setting up the data base.

What I want to do is creat a data base that would allow the selection of a Make of a car from a drop down menu. Then you would select the Model of the car.

What I have so far is the Make set up with a list value set up for Make.

How do I set up the tables etc for the Models? So when some one selects a Make the Model selection would give Models just for that Make.

Do I have to creat a table for each Make and each model?

Help I am lost.

Maybe this post will help.

No I am looking more for teh information on how I create the db. ie do I make a seperate table for each Make and each Model or can I just place them in one tale.

Table 1 would be Make (this produces a drop down list.)

Table 2 would be model (again by drop down)

Or do I

Table 1 Make
field 1 Jag
field 2 Ford
field 3 Saab

Tabel 2 Model
field 1 Jag with list
field 2 ford with list
field 3 Saab with list

Basicaly I need to know how to set up the db to start with.

Yes - you will need a table for make and a table for model. There would be a foreign key relationship between them.