View Full Version : Undo changes to records


charityg
04-17-2001, 08:42 AM
I need a way to undo changes made to a record after a report is printed based on this records. The current system creates a backup of the entire table, and after printing, deletes all records in the table the changes were made to then appends the backup table. Is there a less cumbersome way of doing this? Adding to the confusion is that I want one user to be able to actually save the changes, but everyone else goes back to the original data after printing the report.

llkhoutx
04-17-2001, 12:18 PM
you've either got to have before and after tables or a table with deleted records which can be reappended as appropriate.