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