HiI have a one to many relationship with the detail records shown and added on the main form as an embedded report. I want to get those records from child, where a field(named Error) in child table is NOT empty to add checks on the main form.
To achieve this, I created a reverse relationship with reference field being the max summary of record id where that field is Not empty. At least this gives me one record and I can abort the save on the main form.
The problem is, when user rectifies the problem and that field becomes EMPTY in the embedded report, even then the relationship doesn't cease to exist, even when I hit Save & Keep Working. My idea is if the reference field will be empty, then no relationship should exist and I can allow the Main form to be saved. What could be going wrong? Please advise and let me know in case you need more inputs.
Users enter the information in grid edit on the parent form. It is only after saving the form the reverse relationship establishes.
I want the parent form to be saved only when the "Error" field in Child table is empty, which is actually a formula field which has an error message based upon other fields in Child.
Please let me know if the requirement still needs more clarification.