Compare and return, should be simple.. but

[AJO]

Simple employee training dbase.
Trainings are organised in training sessions, since a session can contain more than one training (i.e. First Aid, CPR, and Fire extinguisher)
Employees belong to departments.
Certain trainings are required working in a department, that dictates requiered trainings for an employee.
Now I have two queries:
'Query emp trng req' returning employee id and their requiered training id
'Query emp trng done' returning employee id and their completed training id.
Obviously I like to know which of the 'req training id's' are missing in the 'done training id's' per employee id
There can be training id's in the done query, that are not requiered for that employee.....
I have the dBase attached, had to strip a lot from it down to <500k...


Thanks for your help.

AJO

[RuralGuy]

FYI, the limit for a zip file is 2MB. Just thought you'd like to know.

[AJO]

Here again the qreq contains required training ID's and the reqdone the completed requiered ID's, now I need the none matching still needed trng id's..
Thanks
AJO