LINK 4 TABLES TO 1 TABLE

  • Thread starter Thread starter O
  • Start date Start date
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create one table using multiple linked tables 6
Create a Form (with Subforms) Based on A Query/Queries 1
Select all entry data from two linked (with a relationship) Tables 4
Access Sorting and grouping using multiple tables 0
Linking tables from existing data 1
Create a linked table 10
Forms and 2 tables 3
linking tables and relationships 3

Back
Top