moving and creating new records

[elvis_impersonating_penguin]

i was wondering if this is possible.. might take some doing...

i am creating a time card database.. and i was wondering if it would be possible to create a script that on Monday morning would move all the records from the previous week into an "archive" database (and maybe aslo export them into an excel spreadsheet so that they can be printed out easily)... and then create a new record for each employee for the current week.

[elvis_impersonating_penguin]

ok i figured out how to move them to an archive database with a script basically i am going to make the script save a copy of the file.. which will work for my needs... now how would i go about deleting all the files from the database after i make a copy of it and then creating a new record for each person in the company..

or maybe a better solution would be to just wipe out everything in all the records except for the people's names, and then have the script change the dates in the database to the current week's dates..?? would this work??

[elvis_impersonating_penguin]

ok.. i think i found out how to create the new records as well... now my only quesiton is how to i make the script run every monday morning...

[elvis_impersonating_penguin]

ok one more question... woooo this is fun... haha..

when you use a script to save a copy of a file it lets you specify the filename in the script and perform the script without dialogue.. what i want to know is if i can set it to save the file as timecardCurrent Date.fp3 for example timecard02012001.fp3