Just asking for an opinion

  • Thread starter Thread starter Jane
  • Start date Start date
J

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
 
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..)
Click to expand...

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