A
Abbey
I'll try to explain this the best I can... I am making a database for my work
to hold all of their training records. So basically I have a table that has
all of the current Document Numbers, their Titles, Revision Levels and
Effective Dates. Then, for each employee I have a table that holds which
documents they've been trained to and at what revision level. Lastly, I have
queries for each Job Title saying what documents someone with that job title
would need to be trained to.
Having said all that, my question is, is there a way to check the individual
employee's training record to see if they have the most recent revision for
their Job Title?
I appreciate any help you can give me. Thanks!
to hold all of their training records. So basically I have a table that has
all of the current Document Numbers, their Titles, Revision Levels and
Effective Dates. Then, for each employee I have a table that holds which
documents they've been trained to and at what revision level. Lastly, I have
queries for each Job Title saying what documents someone with that job title
would need to be trained to.
Having said all that, my question is, is there a way to check the individual
employee's training record to see if they have the most recent revision for
their Job Title?
I appreciate any help you can give me. Thanks!