I new new to Acces and tryig to do something that should be fairly
straight forward. I am trying to have an address book table and link
it multiple time to another table. For example address book with have
people in it who are project managers and quality control. There will
be fields in the other table that call for a project manager id and a
quality control person id. I want to be able to select the people
from the address book and link them to the other table. I only want 1
address book and to be able to link it multiple times to diferent
fields in the other table. Please help this is driving me nuts.
Thanks in advance.

Just add the address book table multiple times to your query. Each time you
add the address book table, join it's primary key field to the appropriate
field in the other table (project manager ID, quality control ID, etc.).
Then add fields from the various copies of the address book to your query.

Access will automatically name copies of the address book with "_1", "_2",
etc. You can create aliases for these multiple copies, to make them easier
to work with. Open the Properties window, click on the table, and write a
name (such ProjectManagers, QualityControls, etc.) into the Alias property.
Now you can work with that copy of the address table with an
easy-to-identify name.

Neil


<tyler.horning (AT) gmail (DOT) com> wrote