G
Guest
I put this questionbefore, but I don't think I worded it very well.
I have a database which I've designed to track Employee Training.
.. I have a number of main tables each linked with junction tables.
One has employee information
One is a list of positions and related info
One is a list of Training Modules Names
One is a table i call training schedules which relates to every specific
time any training is offered (an employee does not just take multiple
modules, they may well take the same module on multiple ocassions over
several years)
These main tables are joined with junction tables.
The two subsets of data I'm comparing are constructed via queries to
generate the following info
One query shows What training is required: and has fields : employeeid,
first name last name, position and module name
The other has the same fields, but the results reflect what training has
actually taken place.
I have constructed a Form and sub form which
shows the info I want on one large page - ie. the employee, what training
they've taken, what training they need, but because it's in a cumbersome
format I wanted an easy
way to Say okay, "Avoiding Back Injuries" - who hasn't taken it - who needs
to have taken it (it's determined via the position held) I can tell from a
simple query who hasn't taken a Module, or even a specific Module ID (a
subject on a given date) but that query just tells me everyone who hasn't
taken it - including everyone who doesn;t need it - I'm probably rambling
but if you need more info please ask again.
I appreciate any help in this
regards
mel Morris
I have a database which I've designed to track Employee Training.
.. I have a number of main tables each linked with junction tables.
One has employee information
One is a list of positions and related info
One is a list of Training Modules Names
One is a table i call training schedules which relates to every specific
time any training is offered (an employee does not just take multiple
modules, they may well take the same module on multiple ocassions over
several years)
These main tables are joined with junction tables.
The two subsets of data I'm comparing are constructed via queries to
generate the following info
One query shows What training is required: and has fields : employeeid,
first name last name, position and module name
The other has the same fields, but the results reflect what training has
actually taken place.
I have constructed a Form and sub form which
shows the info I want on one large page - ie. the employee, what training
they've taken, what training they need, but because it's in a cumbersome
format I wanted an easy
way to Say okay, "Avoiding Back Injuries" - who hasn't taken it - who needs
to have taken it (it's determined via the position held) I can tell from a
simple query who hasn't taken a Module, or even a specific Module ID (a
subject on a given date) but that query just tells me everyone who hasn't
taken it - including everyone who doesn;t need it - I'm probably rambling
but if you need more info please ask again.
I appreciate any help in this
regards
mel Morris