Advanced Joining Queries?

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

I am pretty new to access..I understand how to link to tables
together and I have 3 choices to join them.

The problem is when I try to add a 3rd, 4th, or even 5th table.

I have 2 main tables with customer info....I have them linked by
whats called an equipment #...its 7 digits.

table 1 looks like this.

1234567 scott doe 555 555 5555 6666

Table 2 looks like this
1234567 25 easter lane ct 12211

When I join these everything looks ok It uses all the fields from
table 1 and adds the address in table 2.

I have 3 other tables that use the 6666 codes...each of the 3 other
tables gives descriptions bases on the code it has...I used 6666 as
an example code

How would I link all 5 tables together so it gives me all the info
from table 1, all the info from table 2..then adds the info from
tables 3-5 which apply JUST to what the 4 digit code is? (6666 as an
example)

Thanks
scott
 
Scott

Extend the concept you already have. If you are using the 7 digit ID to
link table1 and table2, but the field that links table1 to table3 is a
different field (field containing 6666), use that one.

Or have I misunderstood your description?

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top