Reverse relationship from an embedded report link

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • In Progress
  • (Edited)

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


Thanks.

Photo of JK

JK

  • 80 Points 75 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
How are your users rectifying the problem? Do they edit the child on the parent form using grid edit in the embedded report? Or are they navigating to a new window and opening the child record?

After editing is there a reason you can't refresh the parent record? Are there likely other changes that the user has made that need to be saved first?
Photo of JK

JK

  • 80 Points 75 badge 2x thumb

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.

Thanks

Ok, I understand the issue now. Can't think of a solution at the moment, but I'll test a few things and get back to you soon.

Ideally the Save and Keep Working wouldn't trigger the Abort the Save form rule... just not sure if that's an option.