2 Replies Latest reply on Jan 21, 2011 12:03 PM by philmodjunk

    Create new record when a date changes



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