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
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.
