Thanks for the ideas guys! I guess I'll be using archive tables and triggers to perform the "sync".

Thanks again.

I need to delete for UI proposes. The user must be able to delete some records. But I need the data so I can use it to generate reports, because...