This is a beginner's question, but is there a way to have two databases, archive and live, and any transactions added in the live will go directly to archive. However, when transactions are deleted in live, they will NOT be deleted in archive. Any help would be greatly appreciated.
Thanks!
Thanks!