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