date search problem
I am new to filemaker and loving it, but I have a little problem that I am trying to work through. I have a table called training that is used to store the type of training, the training date, how long the training is good for, and the last field is a calculation of TrainingDate + (training is good for * 365).
Calculation field works great, the problem I am having is I would like to have a script that runs when the database is opened that will check all the Next training due dates and show an alert when training is 90 days from expiration.
Any help on the problem will be greatly appreciated