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
------------------------------
Original Message:
Sent: 02-12-2020 13:27
From: Gunsham Lakhiani
Subject: Header and Detail Table Field Validation
Hi,
I have a header table and a detail table. In the header table there is a field called Amount which is user entered and in the detail table there are multiple rows in which i want to distribute that Amount which is again user entered in the detail table as well.
I would like to have a validation where in if in the header the user enters an Amount 50,000 then in the detail table it should also be 50,000 which comprises of multiple rows or a single row and the user should not be allowed to save the record till both the header and the detail Amount gets matched.
Is there a way to achieve this?
Regards
Gunsham
------------------------------
Gunsham Lakhiani
------------------------------