A better approach is never to allow deletions from the main table in the
first place. Instead, have a Deleted flag (a yes/no field) in the table,
and set that flag to yes/true wherever you would normally have deleted a
record. Use a query that returns only the records where Deleted=False
everywhere you would normally use the original table. Any time you need to
see all records, deleted or not, use the table itself or a query that
doesn't apply the Deleted=False criterion. And if you need to find only the
"deleted" records, use a query with the criterion, Deleted=True.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
