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.
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.
If([Lookup field of Summary]<9, "Must have more then 9 hours of hours worked and downtime to save please review and change", "")