Saving deleted records (history) (1 Viewer)

[jayme27]

I created a database that keeps track of personnel information; however, I need to save complete record information of those personnel once they leave the organization too. Such historical info regarding these people and their information should be referenced through a form but not confused with those records of personnel currently within the organization. What is the easiest method of taking these personnel off the current records list & preserving this historical data for the user to retrieve upon request. Note, flexibility should be such that you can re-add a historical record back into the current records if a person comes back to the organization. Thank you.

 

[Mitch]

The easiest way if you have a small number of forms, would be to add a Yes/No field to your table, to mark an employee as old then filter your forms to only show records where this is false. You can then have another form which would filter on it being true. Then you could knock the flag off if they return. Other wise copy the stucture of the employee table and make an old employee table then you can transfer the record from one table to the other when ever you like.

Hope this helps.
Mitch