I probably need to understand “list of things” better, the concept escapes me. Also, the logic behind my motive might also be questionable.
That said, I wanted to copy table “A’s” current data so I can create reports from the data in table “B”.
The “originating” data is temporary “A”, its an orders table that gets cleared once the user presses “create order”. Once the order is created, I want to move that data in “A” to another database “B” so I can create reports from the data in “B”.
“A” is reset and ready for a new order.