Location of the script for due date calculation

[Spidey]

Hi Forum,

I am trying to create a simple rent program in which there is a due date calculation. When it is a couple days before the due date, it will automatically create an invoice and receipt in the database.

I am just wondering this script, should I put it there when I open the database or somewhere else. And how can I prevent repetition?..

Many Thanks.

K.C.

[mr_vodka]

If this is a served solution using FMS then you can use a server side script to take care of this. If this is running on Pro then I usually like to pop up a reminder for the end user to run the script.