Retention of records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know if there is a way to retain records of deleted items? I
have two tables: one for assets, the other for employees. Within the same
form it is possible to delete either record. Is there a way to look at these
records in case a question ever arised as to who owned an asset at any given
time?
 
I would add a "Status" field to both tables that allows the user to set a
record to "Inactive" or "Deleted".
 
I would like to know if there is a way to retain records of deleted items? I
have two tables: one for assets, the other for employees. Within the same
form it is possible to delete either record. Is there a way to look at these
records in case a question ever arised as to who owned an asset at any given
time?
Click to expand...

Just don't allow deletions at all, from either table, if this
information may be needed in the future.

This doesn't mean that you can't allow employees to retire or dispose
of assets; instead of deleting their record from the table, though,
simply add a Yes/No field "Active" to each table. Set it to No when
the employee leaves or the asset is disposed of; base your usual forms
on Queries selecting only active records.

John W. Vinson[MVP]
 
Back
Top