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
|