B
BillD
I have a database with approx. 10,000 records. I am constantly adding and
deleting records. When I am in form view and have a record showing, I can
delete the record by clicking on the delete button on the toolbar. Instead of
deleting the record completely, I would like to append the record in a
Deleted Records table with a date and time stamp. This way I can review the
records that have been deleted at any time. Also, if someone deleted a record
that they should not have deleted, I could append the record back to the Main
RecordsTable.
Any help greatly appreciated.
Bill D.
deleting records. When I am in form view and have a record showing, I can
delete the record by clicking on the delete button on the toolbar. Instead of
deleting the record completely, I would like to append the record in a
Deleted Records table with a date and time stamp. This way I can review the
records that have been deleted at any time. Also, if someone deleted a record
that they should not have deleted, I could append the record back to the Main
RecordsTable.
Any help greatly appreciated.
Bill D.