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

Hmmm if it was me I'd left join tblEmp and tblTraining with DeptID, jobclassID joining to ReqDept and Reqclass, pull down names, reqdept and reqclass and criteria for the last two being null. That will pull back all the unmatched records... is that what you need?

James,

Thanks for the quick reply. I'll try that and see what happens.

Thanks,

Brian

Good luck!