How do I design a table to show available years for any specific model vehicle?

  • Thread starter Thread starter good_dragon
  • Start date Start date
G

good_dragon

Hi every one,

I creating a car dealership database.

I need to design a table that will list all available years
for any specific model vehicle: e.g.
Honda (make)
Accord (model)
2000, 2001, 2002, etc. (AVAILABLE YEARS)???

I have created a vehicle Make table for all manufactures.
I also created a vehicle Model table for all available models by any
specific manufacture.

How do I design a table to show available years for any specific model
vehicle?
 
I believe you are describing a one-to-many relationship. That is, one
Make/Model can have zero, one or more "years".

In a normalized design, you'd use a separate table to hold a valid
combinations of Make/Model & Year.

To look them up, use a form in which you have an unbound combo box for
selecting the Make, another for selecting the (related) Model, and some way
of displaying all related Years (a listbox comes to mind).
 
Back
Top