I have not used Filemaker for a few years and quite rusty with databases in general.
I have offered to help a sailing charity by writing a small database that will flag up crews qualifications that are due to expire.
What they would like to see is the course name, issue date, expiry date and months left till expiry.
What I thought might be nice to is if the letting can turn orange if there is 6 months left and red if there are 3months left.
I'm not sure if you can get email notifications on this or is there is any other smart solution.
Seeing as this is a charity, I would really like to help the best I can, so any help will be very well received.