Alarm Date

[dlo1]

i don't even know how to call this but what need is a field that i can add a day/month/year and have a warning valadation message appear 11 months in the future to remind someone of an expiration date. any clues.

[John Mark Osborne]

I think your best bet is to use a script to search for the records. You could have this run when you click a button or automatically each time you open the file. The basic idea is to construct find criteria locating records in the future. I have an example file that demonstrates how to locate overdue invoices but is exactly the same concept as your alarm just farther in the future.

http://www.filemakerpros.com/Overdue2.zip

[thompm65]

Hello,

I would like to take a look at this script also, but I only have FM6. could you copy the script steps to this forum so I could see them?

Thanks, MT