I am new to filemaker and i am being tasked to develop an employee database for our company. The employee database is divided into sections which are: salaries, personal records, timetable and leave. I am currently busy working on the leave section and its not so well. How sick leave works in our organization is that you are given 30 sick leave days for three years. After three years, your sick leave days are reset and you are given new 30 sick leave days.
I would like get all the sick leave days taken by an employee every month. The sick leave days taken in that specific month are than subtracted from 30 sick leave days you are given. I would then like to take the remaining sick leave days from the previous month to the next month and use them as the current sick leave days left. The same will be done for each month until our 3 year cycle ends.
Could you guys please give me suggestion on how to tackle this problem? further questions are welcomed