timed delete

[Keith M. Davie]

I am taking data from one db to another to another. In the process, as the data moves from db 2 to db 3, the record in db 2 is i deleted by script when the new record is created in db 3.

That works fine and good when the user makes the appropriate response in a timely fashion. (The db's are being acted upon by cdml tags - it is a web application.)

The problem is if the user must leave the application before clicking on the button which causes the described action between db's 2 and 3 above. There is no way for the user to get back to the record in db 2 without entering through db 1, which creates the record in db 2.

So a record is created which will not be deleted and is now an undesired record. Does anyone know is there a way to delete the undesired record by a script using a time element.

Obviously the time the record is made can be established using FMP. And a desired delete time could be calculated and displayed in another field. But is there a way to get FMP to cause the deletion of the record if it is still in existence at the calculated delete time?

------------------

Keith M. Davie