Relationships...how to link data???

L

lneel

I have a database with 3 tables.
First Table
Race Date(Date)
Race Type(Text)
Second Table
DriverName(Text)
DriverNumber(Text)
Third Table
BestLapTime(Number)
WorstLapTime(Number)

In a sinlge form I need to be able to pull in Race Date and Race Type,
Driver Name and Driver Number, Best LapTime and WorstLapTime. I can get it to
pull in one field from each table but not both. How do I relate them? Anyone
willing to provide an example? Thanks for your time.

Lee
 
M

MacDermott

Looks to me as if you need a couple more tables.
Since each race may have many drivers, and each driver may be in many races,
I'd use a table with 2 fields, Race and Driver.
While you're about it, I'd add a RaceID to your first table, and a DriverID
to the second table, and make each an autonumber primary key.
Now the new table I described will have fields which match RaceID and
DriverID.

Since the BestLap and WorstLap are presumably for a driver in a race, I'd
add RaceID and DriverID fields to your third table, too.

Now you should be able to build queries to retrieve the data you want.
 
H

Harley Feldman

You can create a query to pull the tables together. However, you need to know which drivers are in which races, and you need to know which BestLapTime and which WorstLapTime are from which race. Once you have these tables associated with the race table, the query will work to pull the data together.

Harley
 
Top