LINK 4 TABLES TO 1 TABLE

O

O

HOW DO I LINK 4 TABLES TO ONE MASTER TABLE? FOR EXAMPLE I HAVE ONE WITH
CONTACT INFO AND 4 WITH SUB INFO. BUT I NEED TO BE ABLE TO RUN REPORTS FROM
DATA IN ALL TABLES AT ONCE
 
W

Wayne-I-M

That is not how access works

You need to link the tables in the relationship window then create query and
run the report from that.

Add the Master Table ID (normally an Aurtonumber) link to the other tables.

Do do this - format a new field in the other tables formated as a number,
then link using these new fields.
 
J

Jeff Boyce

Please turn off your CAPS lock ... all capital letters is considered
SHOUTING!

Do the "4 tables" contain a field that they share with the row identifier
field in your "master" table? If so, create a query and join them to the
master table.

If they do not, how do you propose to "link" them?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top