I am trying to use a field called 'course classes' in my database that is linked to employees. Each employee and a group of employees are scheduled for training which is tracked via the database using couse #, course description and course date. I want to open the courses and add a new course and then add names of the employees without having to open each individual employee to enter that information. Does anyone have any ideas on how to accomplish this? I already have queries and then a form with a subform for courses which gives me the course the employee has already completed with the perspective dates. I need to enter a new course and then check the employees who have recently taken that class.



Any help would be greatly appreciated.