Current Training v. Required Training
I'm creating a database to manage employee training. I have a table called "Employees" that displays all of an employee's current certifications and the date that they received them. Another table, Qualification Table, lists all of the potential certifications that an employee can have. And finally a table called "Job Training Required" that lists the qualifications required for a specific job title.
The "Job Training Required" table lists qualification codes that are associated with a particular noun name of that training (example: T001). That code is associated with a particular noun name on the Qualification Table. Example, T001 = Company Policies.
I want to be able to choose a Job Title on the employee's record table from the popup menu I created and have it automatically compare their currently held certifications with what certifications are required for that job. I would like it to tell me in a field whether they have all the training they need, "All training requirements met", or indicate the noun name of the training that they need to get in order to have all training requirements met. I am not quite sure how to go about that (what function or script I would use, syntax, etc.).
If anyone has any suggestions or info, thank you.