Copy multiple records between tables

[Greg58]

I have a TODO List.  Some tasks I want to put off to tomorrow, but have them reappear on my TODO List the following day.  I have two tables; TODAY, TOMORROW.  I can get the individual records to go to tomorrow ok by just using a button with a script.  This operates on one record at a time which is fine.

I am having problems getting the records in the TOMORROW table to automatically come back to the TODAY table the next day.  I date the records when they are sent to the TOMORROW table, and have tried to use this date as the criteria for them to re-appear in the TODAY table.  One problem would seem to be that there are often multiple records to be sent from TOMORROW.  I have tried to set a script trigger on the file itself so that when I open it the next day it sends the records back to TODAY.

Any help is appreciated.

[Greg58]

Sorry.  Just realised this is on the wrong forum...