I have an issue with validation rules that I would appreciate some help with.
I have two tables for timesheets – one for header (date, employee, shift) and another for line item details – job, hours worked, downtime. The relationship is one header to many line items.
I want to enforce a rule so that there must be a minimum of 9 hours (hours worked + downtime) for each header.
Any ideas on how I can get around this much
The problem I have is that the total is held in the header record, and it’s the child records where the user makes changes that affect the total, so the validation rule isn’t triggered by saving the child record(s) . If I click save on the header record it’s triggered – but of course the user has no actual need to trigger save on that record because the total hours figure gets updated automatically via the relationship.