I 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.