I have a summary field that counts the number of records in a child report (grid edit) that are checked. I would like the user to be warned if there are no child records checked but in a parent field I have a value that indicates that child records should be checked. The user then has the option in edit mode to either change the parent field value or check one of the child records (in an embedded grid edit report on the form)
The problem is that the summary field for the checked records in the child table do not calculate until the form is saved and then it is too late to notifiy the user that they have a descrepancy between the Parent value and the summary field.
Is there a way to catch this descrepancy real time (before or as the record is being saved). I have tried having the embedded report and parent fields load at the same time but that does not catch the descrepancy.
------------------------------
George Bramhall
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.