Retention of records

[Christopher]

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?

 

[Duane Hookom]

I would add a "Status" field to both tables that allows the user to set a
record to "Inactive" or "Deleted".

 

[John Vinson]

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?

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]