Trigger validation rule in parent record
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,...
Forum Discussion
Hi Jonathan,
When working with the validation rules and running into an issue like that one suggestion I make is once you have the summary field up to your Header table you can then create it as a lookup field down to your Line Item Details table, this way as you add more records to the Line Items table it will lookup the value of your summary from Header. That way you can write your validation rule on the Line Items table to use your lookup field to prevent a save.
I believe that should allow you to create the validation you need. I hope that is helpful.
When working with the validation rules and running into an issue like that one suggestion I make is once you have the summary field up to your Header table you can then create it as a lookup field down to your Line Item Details table, this way as you add more records to the Line Items table it will lookup the value of your summary from Header. That way you can write your validation rule on the Line Items table to use your lookup field to prevent a save.
If([Lookup field of Summary]<9, "Must have more then 9 hours of hours worked and downtime to save please review and change", "")
I believe that should allow you to create the validation you need. I hope that is helpful.