As a work around you can just add the new field in the Procedures Table.

I do not see dates when training was received. Some training is reoccuring
like every year. The table needs to have a field for that. List all your
training requirements and figure out the common calendar cycle to use. If
nothing is less than a year then use increments of years except for one-time
training that will have an interval of 0 (zero).

Some training records are required to kept for an extended period by law.
If your Human resources or trraining branch is not maintaining hard copy in
the personnel folder then the database would be your legal records.

I will post more if you want.

"Karen" wrote:

I have a DB that someone who once worked here created. The DB is not set up
properly and I don't have the time to create another one and learn how to
import all this data. Therefore, I have to work with what I have. This DB is
used to track our company traning procedures for each employee. There are no
primary keys set up and the employee table has the first and last names
combined in one field - to give you an idea.

Below are the table structures:

Employee Table:
EmployeeName
EmployeeNumber
DateOfHire
TerminationDate

Procedures Table:
ProcedureNumber
ProcedureName
ProcedureType

Training Grid Table:
ProcedureNumber
TrainingType
EmployeeName
DocumentationDate

Training Type Table:
Training Type

We have changed our Procedure Numbers and they are now called NT Numbers.
We are in the middle of changing over all the procedure numbers to the new
numbers. In the mean time, I have to track this info in our database. As far
as I know, a query should have been created to be used for data entry and the
previous employee is using the "Training Grid" table for that purpose. How
should this DB be changed so I can add a new field for "NT Number" and have
each NT Number correspond in there respective record with the old procedure
number? I hope I am explaining this so it is understood. Please let me know
if I'm not - I really need to start entering the new numbers.

ANY help would be greatly appreciated