Is there a way to simply copy the full contents of a record to another table or file? What I want to achieve is, when a user clicks the delete button, the record is copied into a another table or file for me to review and restore records if necessary.

I have been able to achieve it by setting up a related table using lookups etc, however I thought there might be a more elegant option.

Probably less elegant but easier.

Export your record (into a temporay file) and then import it into your archive file via an external script.

Sounds like that will be a lighter and easier option, thanks for the help