Looking for some direction on archiving records. I have 2 tables; Table1 and Table1Archive. What I’d like to see happen is for a user to be able to check a box on different records. This check box would be labeled something like “Purge and Archive.” After going through and marking the records for ‘purge and archive’ the user would click a button that would copy these records into Table1Archive and then delete/purge them from Table1.
We see Table1 expanding in such a way that we would not even want to filter archived orders. We just want them out of the way, accessible from a different layout if needed.
What is the best way to manage this?