Query from multiple tables

  • Thread starter Thread starter PA
  • Start date Start date
P

PA

Using Access 2007, the db has 11 tables on job assignments.
SrDirector and Director(primary key) in one table
Director and Mgr (primary key) in another
Mgr and Assoc(primary key) in another
and Assoc and Job# in yet another (this is a dual primary key)

I am attempting to design a query to match up the reporting path for
associates, that is an Assoc reports to Mgr who reports to Director who
reports to a SrDirector

Any suggestions will be of aid.
Thanks
 
a key field of Table1 must appear also on Table2 (sometimes referred to as
the foreign key) in order for there to be cross referencing. This must be
repeated as needed with all tables.

one can permanently make these relationships between tables; or when you
create a query, in query design view; add the tables and create the
relationships.
 
Back
Top