there are two tables
Parent table :Branch
Child table :employees
grand child table: Reports
in the Branch table there are Overtime fields for later vadiation purpose so that the number of employees reported later by each branch does not excced the limits fixed in the branch table there are 3 types of overtime (2hours, 3 hours and 4 hours)
for example Branch A is limited to Report a total of 2 employees for the category of 4Hour overtime, 3 employees for 3 Hours Overtime and 1 employees for a 2 Hour Overtime but the employees are not fixed, they may change as per situation
the question is how to count the number of each overtime type per branch and set it on the validation field so that whenever they fill or report more than the limits fixed, they get a message, however in order to count the numbers of 4H, 3H and 2H, i seperated them in 3 fields of OT and 3 fields of Summary,
Tried the following also:
i used Getsummary,
i linked Branches table to the report Table in order to generate breakfield, i sorted by branch but it didnt worked .
what am i missing??!!