Create new record when a date changes
Thanks in advance...
I would like to create new records in an existing Table, when the date in "Date" becomes older than the date in "Today." ("Date" is a calculated field that is an expiration date)
The new record would have most of the same information as the original record, but some of the data would change...
I'd like to have a script run and add the new records automatically when the DB Opens? Unless there is a better time... There are about 20K records in the table so far. I expect about 20-30 new records to"Expire" each day, and I'd like to automate:)