query Design Ideas ;-)

[wildcat]

I am sure there is something on this site concerning this issue, but I am fairly new to Access and am not sure what to look for.

I have a daabase that has:
tblStaff
..AutoID (Primary)
..StaffID
.. etc

tblAssignments
..AutoID (Primary)
..LocationID
..JobID
..StaffID (linked back to tblStaff via relationship)

I would like to create a query that would allow me to select StaffID from the tblStaff only if that StaffID is not in tblAssignments.
Essentially I want to make the query automatically remove people from the list once they have been assigned a job and location.

Any ideas and help would greatly be appreicated.

 

[DCrake]

Suggest you use the unmatched query wizard to create the query you want.

 

[wildcat]

Thank You - I will give that a try. I didn't know that existed.
Thanks