database duplication

We are looking at having a second database that captures amendments to the fields of the first one.

It would be good on edit of success that the files were sent to another form/database.

Can this be done?

Thanks

Andy
helpdesk