Duplicate current record to another table upon record exit

[lee2121]

I have two identical tables only one of them has data inputted into it the other table has no user access.

 

After a user has created a new record in Table A i want all of the data to be duplicated into Table B and just stored there. This is because Table A can later have individual records deleted and we need to keep a backup of all the data entered into Table A

I did write and export script which exported the record from Table A to excel and then imported the excel file into Table B but this does not work very well over our network.

 

Any suggestions would be appreciated.

[comment]

Any suggestions would be appreciated.

​I would suggest you rethink your overall strategy, as it makes very little sense to allow users to delete records but also want to keep them.

Edited June 3, 2015 by comment