Hi have a requirement for form to automatically re-query after some logic in pre-update trigger.
The issue is: I have a SalesOrder header with multiple lines. If certain fields are updated in one line record, A YES/NO Alert pop up asking the user if he/she wants to apply the changes to all the other line Items. and
Note: to see the other updated lines, please requery. IF The user presses YES then
The trigger is in PRE_UPDATE of the SalesOrder Line. What the trigger does is that it go into the database via a procedure call, and for that SalesOrder header record, it will update all the other lines with the updated fields. The requirement is that User does not want to re-query to see this changes anymore. They want the query to be done automatically.
Question is : We do not use timer here and how can i implement this automatic re-query. Thank you
Sketchy example is as below.
SalesOrder Number: 'SO123'
SalesOrder line
Line product AENO FSNO
1 1A AE12 FS12
2 2A AE22 FS22
3 3A AE33 FS33
. . . .
. . . .
Nth NA AENth FSNth
IF Say line 1 AENO value is Changed to SS12 . An Alert pops up in pre- update to check if you want to change the value of the other lines to SS12 . A procedure is called to update all the other SalesOrder lines for SalesOrder header 'SO123' with the updated field in the backend where salesorder line <> 1 (That is the line is not the current line been updated). The question is how does the user see this changes automatically without re-query the Salesorder Line?
Thank you.