Hi Mark,
Yes an employee will apply for a leave.
Then I should create another table called tblLeaveApply with
LaLeaveID
LaEmployeeID
LaDaysEntitled
LaDaysUsed
DaysLeft: Nz([LaDaysEntitled],0)-Nz([LaDaysUsed],0)
Is this system designed to tell them what that leave will be? Yes, it should...