AnsweredAssumed Answered

Getsummary count by breakField for record validation

Question asked by hikmat on Jul 20, 2018
Latest reply on Jul 22, 2018 by philmodjunk

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??!!

philmodjunk

Outcomes