I need a suggestion for a table layout

[jjake]

Hello.

I have 4-5 types of data i would like to store.

Motorcycles - make, model, year, color.
Cars - Make, model, year color, door numbers
Trucks - Make, model, year, color, towing capactity
Boats - Make, model, year, size, motor size

What would be the best way to set this up. Should i put all the data into one table? Should i do a table for each type and make another table for vehicle types to link to?

If i do make another table say tblTypes - Motorcycles, Cars, Trucks, Boats.

How would i go about pulling them up into one combobox if they were all in separate tables?

 

[pbaldy]

I would have a single table with a field for the type. I'd probably also have the tblTypes which would provide the available types.