"Deleting" records to another database

[murray]

I am interested in implementing the technique of saving "deleted" records into another database to track these. I have 15 separate dbs in my solution - is it better to have a "deleted" database for each of these or somehow combine a single database of all the db's deleted records?

If this is the case, I'd appreciate any advice on how to set this up.

Cheers, Murray

[Henry]

For this case, i think you better have a "deleted" database.You can only create a single "deleted" database rather than 15 database. Before you delete the record, you can add a script to copy all fields on this record to global fields and then go to the "deleted" database and create a new record then put all the global fields into the record.

Hope this tips can help you.

Regards,

Henry

[murray]

Thanks Henry,

I'm still not sure how to implement it as some of the databases may only have 20 fields in and others have 300. I'm not sure how I would set up the "Deleted" database to handle the differences in the fields.

This may be a stupid question but do you mean copy the fields or copy the contents of the fields?

Can you give me a liitle more information - I'd appreciate it greatly?

Thanks, Murray