Data warning when entering records into embedded grid edit form
I've got a tricky problem that I want to solve:
My users frequently enter data to a child table "Child A" through an embedded grid edit report on a Parent table form. This parent table has its own parent table, which I'll call the Grandparent table. Sometimes, the data being entered into the "Child A" table through the embedded report matches data in another "Child B" table. Basically, the users need to know if there is a B record which shares a Grandparent with the new A record, and also shares a text field value. In those situations, they don't want to enter the A record.
In those situations, they ideally want to be notified while entering the A record of the existence of the B record, like in the form of a pop-up warning. That seems really tricky, so I've also been investigating ways to, when the user attempts to save the Parent record, abort the save and notify the user of the existence of the B records. I've also been investigating having a simple message appear below the grid edit report telling the user of the B record. I haven't been able to figure out a way to implement any of these possible solutions.
Does any of this make sense? Is there a solution?
My users frequently enter data to a child table "Child A" through an embedded grid edit report on a Parent table form. This parent table has its own parent table, which I'll call the Grandparent table. Sometimes, the data being entered into the "Child A" table through the embedded report matches data in another "Child B" table. Basically, the users need to know if there is a B record which shares a Grandparent with the new A record, and also shares a text field value. In those situations, they don't want to enter the A record.
In those situations, they ideally want to be notified while entering the A record of the existence of the B record, like in the form of a pop-up warning. That seems really tricky, so I've also been investigating ways to, when the user attempts to save the Parent record, abort the save and notify the user of the existence of the B records. I've also been investigating having a simple message appear below the grid edit report telling the user of the B record. I haven't been able to figure out a way to implement any of these possible solutions.
Does any of this make sense? Is there a solution?
