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

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

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