How should I set up tables for this situation?

[sjs94704]

I am creating a database for practice. For this database it is for a car rental agency. So, what would happen is the agency would obtain a car that would be made available for rent. The user enters the car into a form which is the car profile.

As part of the car profile, there would be two combo boxes. One for make, the other for model.

My desired result is that once the user selects a car make, then the model combo box would be limited to only the models for that make.

I currently have one table for makes of cars that looks like the following:



CodeCarMakeID (Autonumber, Primary Key)
CodeCarMake (Text)

However, I'm not sure how to design the table for model in order to accomplish my goal?

I'd appreciate any suggestions

Thanks in advance

Steven S
Berkeley, CA USA

[June7]

tblModels
Model (this can be PK or can use an autonumber field as PK)
Maker (the autonumber from tblMakers or the actual name - Ford, Chev, Mazda, etc)

Review this tutorial http://datapigtechnologies.com/flash...combobox2.html