I am developing a small leave database which will store all the leaves taken by an employee. I am currently busy with sick leave but finding difficulties. I would like to have a script which checks every month for sick leave days taken by an employee. It will then subtract the sick leaves taken from 30 sick leave days which are given to an employee for 3 years. I would like to take remaining sick leave days from the previous month to the next month until the 3 year cycle ends.
Could you please show me the right direction because I am still new to filemaker. Thank you