Updating a database created by someone else

[Guest]

I am updating an Access database created by a former employee that we use to
track employee training as part of ISO, using ACCESS 2002-2003.

When a WI/PRO is updated it is entered into the database incrementing the
revision level by 1 (Assy-010-01 would become Assy-010-02).

Employees are trained and/or training is required on job titles. The way
the dbase is currently set up is that when the revision is entered the old
one is made obsolete using a check box and the new revision becomes the
current required training.

The problem is that when this change is made each and every job title must
be reentered as requiring training on the revised WI/PRO.

Is there anyway to tell access that when the WI/PRO is revised the job
titles from the earlier revision should be included in this revision?

Thanks,
Leslie

 

[Guest]

What about a select query to pull the old records. Make it an append query
to create new records but the field for the verison just change it.
The field row would look like this as a select query --
Job_Title WI/PRO YourOtherDate Fields

The Append To row would look like this as a select query --
Job_Title WI/PRO YourOtherDate Fields

The field row would look like this as a APPEND query --
Job_Title NewWI/PRO: "YourNewCode" YourOtherDate Fields