Archiving updated records

[Payner]

Hi All, i am creating a database for work for the calibration of our inspection equipment, all equipment has a limited time of use before re calibration is required. Also equipment gets scrapped etc. What i require is a table that archives all the updates of these records, ie saves a history of all the updates for every piece of equipment, be it yearly calibration for 10 years or scrapping after 1 year. We will need to search the history of updates when we have a quality assessment in progress to show the history for a certain item.



Please help

Many Thanks

[June7]

You want to 'archive' data of scrapped equipment? Just have a field in the equipment table that indicates the status (active, scrapped, sold, whatever) of equipment. Use that status to aid in sort/filter of related records.

[Payner]

Thanks for the reply June7, I have already done that, but to get ISO accreditation you must have a history trail, so I need to archive all records at anytime they are updated, so whether it's scrap, been re calibrated or the location has moved this needs to be archived to show changes in the records.

[June7]

Here is example of an audit log http://allenbrowne.com/AppAudit.html
The idea is to create a historical record for any edits done to a record. I mean if you corrected the spelling of a word, say 'personal' to 'personnel', an audit log record would be created. Is this what you want?

If what you really want is just to document events (sale, transfer, acquisition, calibration) that can be maintained in a related table.

Master table of assets - AssetID, S.N., P.N., description

Events table - ID, AssetID, EventDate, EventType, etc

[Payner]

Once again thanks June7,
This looks more like what we require, i will go through it and try it out, it may be a bit of overkill but at least any changes will be archived, better too much information than not enough.
Cheers