I am trying to setup a database that records Employee Leave, I have Two tables, one EMPLOYEES and EMPLOYEE LEAVE. In EMPLOYEE LEAVE, I have used the EMPLOYEE names and EMPLOYEE ID from the EMPLOYEE table as the Primary key. The problem is this, I have so far managed to get the data in the Form to calculate how many month leave an employee has accrued till the current date, but need a way to add the total days leave they have taken so far in the TOTAL DAYS TAKEN field that is in the EMPLOYEE LEAVE table and only add the TOTAL DAYS LEAVE for each individual Employee per record at any given date. I intend to use this value to subtract TOTAL LEAVE TAKEN from another field LEAVE LEFT which will them give a value for TOTAL LEAVE AVAILABLE.
I am relatively new to this, so please assist where possible.