Header and Detail Table Field Validation

Here is a solution for you Gunsham. 

This relationship, summary field, and lookup fields allow you to check the amount being entered into the Details table versus the remainder and with a dynamic form rule, not allow a save by clearing the Amount field when the Amount is greater than the remainder.

With one record in the Details table having an amount of 49999.9999, the remainder is near zero.

While entering the amount, [Validation] is checked because the amount is not compiled yet, but on clicking outside the amount field or by clicking save, the amount field is cleared and the record cannot be saved because the amount field is required: Here is the form rule:






------------------------------
Adam Keever
------------------------------