Calvin,
While having trouble with my other thread Method Directive to prevent save if conditions are met - #20 by ckrusen, I stumbled onto this thread.
I tried to fill table by Query, but it seems that the ttPORel has no data (when state changes from unconfirmed to confirmed; the save has already occurred when the approved checkbox went to true and I assume this clears the temporary table). I realized this when I set messages that would show me the values for the OTSAddress1, 2, and 3 and they were all null. Then I tried three Set Variable widgets (for PONum, POLine, PORelNum) and got this:
I think I am really close to solving my issue. I am trying to fire a message when anyone tries to confirm the PO, when any release on that PO is Buy to Other (PUR-UKN) and the TranGLC.SegValue1 for that release is “999999” or “120000” or “120100” or “120200”.