Auto Run Script

[cybertaz]

I have a script that syncs two databases (a & by just importing and updating the new records. I have two questions.

1. How can I get the script to delete a record in database "A" if it does not exist in database "B".

2 How can I get the script to run every hour to update records. Thanks.

j

[SteveB]

Troi has a plugin called Activator that can run scripts in other files at given times. See his line of plugins at www.Troi.com

[Gerd Muller]

1. Make a relation from "A" to "B" with a uniqe record id. In "A", create a formula that looks for related records: set the field to IsValid(:record_id). The result will be 1 for records existing also in "B" and 0 for records not existing in "B". Search for the 0 and delete them.

Gerd