I have a database of ‘items’ that can be assigned to ‘users’. This database is constantly being updated by an ‘admin’ that is adding and removing ‘items’ as well as changing the current ‘user’ that an item is assigned to. I’d like to save the daily history of the ‘items’ log by having the ‘admin’ click a button at the end of the day that will then copy all of the records from the ‘items’ database into a ‘dispatch log’ database and but also have one more column that has the next days date. That way, I can always go back and get the history of each item. I know of a way for the ‘admin’ to manually confirm each item and create individual ‘dispatch log’ records but my ‘items’ log is going to have ~150 records on average so that we would be time consuming.
Any ideas? More than happy to get on a zoom call with someone to better articulate the problem.