I don't know if there's a way to do this that won't require a page full of scripting, but I'd like to create an auto backup function to enhance my record deletion button. What I'd like is to be able to backup the record they're deleting into a temporary table (a copy of the original) in case they realize they need to retrieve it after pressing the Yes-Delete-This button.
My thought is that I'd periodically clean out the backup table based on a length of time - say anything older than 15 days - but keep newer records available in case there's been a mistake made.
I'm hoping there's a way to select the record, copy it and then paste it into the backup table. However, I don't want to have to spend days writing the script or trouble shooting it becuase, to be honest, the user is prompted multiple times to verify the record really should be deleted.
I have seen a few examples of copying records, but those have involved only partial records and I want to copy every field for the record into an exact duplicate of the original table.
Is this possible?
DD