User alerts upon opening the database

[rebeccaatemc]

I do hope that I have I am posting this question in the correct folder...

One function of my company's database is to keep track of the proposals requested of us. Each proposal has a due date. My goal is to run a script when the database opens that alerts the appropriate personnel to an impending deadline.

Each record in the proposals table has a corresponding "due date" and "lead analyst" (i.e.the person writing the given proposal). Is it possible to write a script that searches all of the proposals for ones due within, let's say, three days, and then alert the corresponding lead analyst? We don't want to miss deadlines after all...

Thanks for any help you can provide.

[xoomaster]

Are you having a problem with the scripting part ?

Just freeze the screen and check the date field by

( if Get(currentdate) - 3 > the_Specifice deadlinefield_value) and take the users to a layout to show the found set if the count is > 0.

The script should be a "start up" script, set at the File Option in FM 8.5.

I hope this make sense to you.

Xoomaster