First, it sounds like you have a design problem. Your tblPersonDepartment
table should look like:
DepartmentID, PersonID, PersonPosition (Boss, Secretary, Worker)
This allows you to have 0-n people in each department.
But to answer your question, you would need multiple copies of Table2 in any
query to "lookup" each Boss, Secretary, or Worker in Table1.
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Oakley
Sent: Wednesday, May 31, 2006 10:28 AM
To: [email protected]
Subject: [ms_access] Multiple lookups
Sorry if this is a dumb question that's been asked before, but I can't
work out how to do multiple lookups to the same table in the one query.
Table1 contains department details including a personID in each of the
boss, secretary and worker fields.
Table2 contains people detail, including personID and names.
I want to look up a department and find the names of these people, but
this needs multiple lookups into the same table.
The tables are not otherwise connected, because some people can work
in more than one department.
What obvious answer am I missing here?
DaveO
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
