course completion program

[Poweruser99]

I have developed a database application for my department. basically our employees have the option to take internal educational courses. They are awarded certificates once they complete a set number of courses. We have around 8 certificates to be awarded, and each ones course requirement varies.

The department wants to keep track of which employee has completed which certificate. This should be triggered when the employee has completed a set number of courses for the certificate. For example if one certificate has 6 courses to be completed, and an employee does complete all 6, then some kind of report needs to be generated.
This project has to be built in access.
There are 5 departments and each 5 department is only entitled to one kind of certificate.

As mentioned before one certificate can have many courses in it, and one course can be applied to many certificates. I got that part of the many to many relationship right.

The application has more requirements which I have met, but to make a trigger for a certificate has confused me. Any help in coding this would be appreciated.

 

[FancyPrairie]

When the user indicates that an employee has completed a course, in the AfterUpdate event of that control, check to see if the user has now completed all required courses, if so, then DoCmd.OpenReport "ReportName",,,"yourWhereClause"

Where "yourWhereClause" would be something like:

"EmpId=IDofEMPonScreen and CertificateID = CertificateCompleted