I wonder if someone could give me some advice on something I am looking at.

I am starting to build an application in Zoho Creator that will import data via csv files from other applications.

The 'live application' will only be interested in looking at the data from the last import but I want to keep an archive off all data uploaded so importing and deleting current items wouldn't be suitable.

So is it possible to import to two different tables at the same time with the first adding the records and the second deleting all and adding new ?

Or if not possible, would it be possible to have a process where immediately after importing a batch to one of the tables, the user is forced to click a button labelled (refresh, save, update or whatever) that actually copies the latest import over to the other table?  My concern with this would be if the process wasn't completed and the browser closed down for whatever reason.

Many thanks for your help, it's appreciated.