Comparing and flagging results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two databases. One contains a list of documents, all associated data,
and their latest revision number. The other db contains various personnel
data including the documents they have been trained in and the revision
number of the document. I want to compare the two revision numbers to ensure
that the employee is always trained in the most recent version number. In the
report that I print of the employees training I want to flag the revision
number if it does not match the latest one.
 
In Access, a database is the .mdb file, a Table is the storage object for
data. So, I think you're referring to two tables, and answering
accordingly.

I think your answer starts with... You don't have enough tables, but only if
you need to retain the data about previous training that an employee had for
past revisions.

Here is the schema I would have for that situation:

Emps
------
EmpID
EmpName
....

Emp_Training
--------------
TrainingDate
EmpID
DocumentID
DocVersion
....

Documents
------------
DocID
DocName
DocVersion
....

From there, a couple of queries, which append data to a temp table, of which
the report is based, would gather the following data:
a. Those emps w/o any previous training on the document
b. Those emps w/ previous training, but not the right version
 
Thank you Steve that is great information on how to set up the tables. I was
wondering that as well. BUT I still do not know how I make the judgement that
the employee has been trained but not on the right revision number.

Can you help me with this one?

Sharon
 
Back
Top