AnsweredAssumed Answered

Create new record when a date changes

Question asked by DaveNeedsHelp on Jan 20, 2011
Latest reply on Jan 21, 2011 by philmodjunk


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:)