Reply to thread

Message: [QUOTE="Steve, post: 10471917"] You need to redesign your tables: TblEmployeeType EmployeeTypeID EmployeeType TblEmployee EmployeeID Firstname MI LastName EmployeeTypeID etc TblTrainingCourse TrainingCourseID TrainingCourseName TblTrainingCourseRequired TrainingCourseRequiredID TrainingCourseID EmployeeTypeID TblTrainingCourseTaken TrainingCourseTakenID EmployeeID TrainingCourseID You can now use an unmatched query to find the courses required for each employee by his employee type in TblTrainingCourseRequired that are not in TblTrainingCourseTaken for each employee. To create an unmatched query, go to Queries at the database window, click on New and select the Unmatched Query Wizard. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications [email]resource@pcdatasheet.com[/email] [/QUOTE]