many to many relationship ?? 1

[solo7]

I want to create a Db to cross reference types of vehicle and the respective drivers. One driver can drive many types of vehicle and many vehicle types can be driven by one driver.

Is this the infamous many to many relationship ??

If it is then can someone point me in the right directon in designing a Db which can query all the drivers for a certain type of vehicle and catagorise all the vehicles a driver can drive.

Steady ...

 

[MattJW]

You need to you 3 tables in this circumstance

Table 1 - Drivers
*Driver ID
Driver

Table 2 - Cars
*Car ID
Car

Table 3 - Xref
*Driver ID
*Car ID


* - indicates key fields

The Cars and Drivers tables both have a one to many relationship with the Xref table.

Hope this helps!

 

[solo7]

Thanks Matt
this does help as it keeps the answer in my limited skill range.

Cheers Steady ...