I would like to add a button to a form so that when clicked all the data in that record is moved (cut and paste) to another identical table, like archive.
I want the action to act as a delete, however instead off deleting i would prefer it to be stored in another backup table. a safty net. Any...