Hi Alex/Richard,
I've created a Training Database and need help. I would like to have a subform populate with all Mandatory & Recommended Training required for that Position Title when I select it in my ComboBox on the main form. I also need to use this form for any other additional training & qualifications the employee may have completed or previously obtained. In addition, some training has timeframes for when it must be completed from date of employment.
1. EmployeeID
2. Course Category
3. Course Name
4. Course Requirement (Mandatory (Red) or Recommended (Light Orange), Completed(Green))
5. Course Duration (1 day, 2 days, 1 week etc...)
6. Course Due Date (the expiry date from date of employment)
7. Obtained Date
8. Expiry Date
9. Course Provider
10. Subject Expert

You help would be greatly apricated   also if you have free already covered something similar please let me know where I can find the training.
Many thanks
Gina D

---

Reply from Alex Hedley:

Have you created your Queries to get the information you require?
You can then create SubForms displaying this information, filtered on EmployeeId.