I have a table named "cases" that stores a number of cases that need to be viewed by a list of users, the table contains an AutoNumber field named "CaseNo"
A separate table named "caseschecklist" records which users have completed certain cases and contains the field "StaffID" (identifies each user by an assigned number which is also stored in the global variable "currentStaffID"), "CaseNo" which essentially gets populated with a record everytime a user looks at a case. Another Field on that table "Complete" is a true/false field that becomes "True" when the user completes a case.
I would like to open a form that will open the table "cases" for a certain user but only select their incomplete cases - i.e. use the table "cases" only including the records where "CaseNo" has no matches to "CaseNo" in the table "caseschecklist" where for that "StaffID", "Complete" is true.
Hope this makes sense and I appreciate any help.