Show data in form from multiple tables?

  • Thread starter Thread starter alistair.calder
  • Start date Start date
A

alistair.calder

I have a player database that has multiple tables (PlayerName, Stats,
Salary) and I would like to show all of the related from the player on
the same form.

The PlayerName table has a PlayerID field that is linked to both the
Salary and Stats tables.

When I look up player X, I would like to have the associated record
come up with all of the related data from the linked tables.

How do I go about doing that?
 
Put them in a query to be used as record source for the form. Join the
tables on common field - PlayerID.
In query design view click on the PlayerID field of PlayerName table and
drag to PlayerID field of Stats. Click on the connecting ling and select the
item that says all records from PlayerName. Do the same for Salary.
 
Back
Top