Ok so i have 2 tables. driver and team, each team has a maximum of 3 drivers.
driver has fields driverid and drivername, with driver as the primary key
team has teamid and teamname, with teamname as the primary key
I then have a lookup table, which assigns each driverid to a teamname.
I'm trying to make a query with the format:
teamname teamdriverid1 teamdrivername1 teamdriverid2 teamdrivername2
I'm presuming i need lookup functions for this but need help on it.
You only need a lookup table if you have a many-to-many relationship. Answer these two questions:
1. Can a driver be on more then one team?
2. Can a team have more than one driver?
Number two has already been answered, but if you answer Yes to number one then you have a many-to-many relationship. If that is the case then you need the third table. Otherwise you only need two tables, one for drivers (with a TeamID field) and one for Teams.
Thanx for the replys, ok i got rid of the lookup table, i just thought it was needed to make this query in that format. I'm doing this for a friend who's importing the database into mysql, which apparently supports very little in access. When trying to make the query i can get a new record for each driver of the team, i.e.
But he specifically says he needs all drivers in a single row.