tgs wrote:But deleting a record can't be canceled with a rollback.
Thank you for your suggestions.
Instead of actually deleting you can set a 'deleted' flag on the record, and exclude 'deleted' records when searching. You will need some way of showing 'deleted' records so they can be un-deleted by clearing the flag.