Hello,
I have been tasked with setting up a database to track employee training. The easy stuff is to track completed trainings by employee. Additionally I need to be able to track the status of required training by both department or job class. My inital table structure is:
tblEmp
pkEmpID
LastName
FirstName
DepttID
JobClassID
tblTraining
pkTrainID
Topic
ReqDept
ReqClass
tblTrainDetails
pkID
fkTrainID
fkEmpID
DtCompleted
Where I am stuck is how to best query for training that has not been completed but is required for an employee based on either department or job class.
I appreciate any suggestions and if I can get this put together will gladly share the db as an example.
Thanks in advance,
Brian
I have been tasked with setting up a database to track employee training. The easy stuff is to track completed trainings by employee. Additionally I need to be able to track the status of required training by both department or job class. My inital table structure is:
tblEmp
pkEmpID
LastName
FirstName
DepttID
JobClassID
tblTraining
pkTrainID
Topic
ReqDept
ReqClass
tblTrainDetails
pkID
fkTrainID
fkEmpID
DtCompleted
Where I am stuck is how to best query for training that has not been completed but is required for an employee based on either department or job class.
I appreciate any suggestions and if I can get this put together will gladly share the db as an example.
Thanks in advance,
Brian