Just asking for an opinion

[Jane]

Hello there,

I have a project to set up from scratch and I would like to ask your inputs.

I need to connect ACC to SQL2k and create new tables, forms, etc. as needed.
The data will include the following:

Cars...
Dealer name, buyer name, make, model, etc.

Trucks...
Dealer name, buyer name, make, model, etc.

Motos...
Dealer name, buyer name, make, model, etc.

Boats...
Dealer name, buyer name, make, model, etc.

As you can see, there's lot of common data but under 4 different products.

The Q: I have is... should I
1) group the tables containing their own data e.i.: tblDealers, tblCar,
tblCity, etc... tblDealers, tblTrucks, tblCity, etc...

or

2) should I crunch all the data in one main table e.i.: tblDealers,
tblProduct, tblCity, etc.. and link the main table with tblType (cars,
trucks, etc..)

Any inputs is appreciated.
TIA
Janet

 

[John Vinson]

2) should I crunch all the data in one main table e.i.: tblDealers,
tblProduct, tblCity, etc.. and link the main table with tblType (cars,
trucks, etc..)

That's how I'd do it. tblVehicles with fields for Dealer, Product,
City etc. (linked to tables of dealers, etc. as needed).