Dear List,

I am building a master/detail data entry and need your advice.

Master Query.SQL (simpified):
SELECT SO_PK, SO_NO, SO_DATE, SO_TOTAL_AMT FROM SO ORDER BY SO_NO

BufferSynchroFlags - all set to True
RequestLive = True

Detail Query.SQL:
SELECT SOITEMS_PK, SO_PK, PRODUCT_PK, SOITEMS_QTY,
SOITEMS_PRICE FROM SOITEMS

BufferSynchroFlags - all set to True
RequestLive = True

TIB_Transaction:
Isolation = tiCommitted
ServerAutoCommit = False
AutoCommit = False

SO_TOTAL_AMT in SO table is update via trigger in SOITEMS table (After Insert, After Update, After Delete).

One TIB_Edit control (edtSO_TOTAL_AMT) is attached to SO_TOTAL_AMT.

Question: How I refresh edtSO_TOTAL_AMT immediately to reflect the new value of SO_TOTAL_AMT after updated via trigger in SOITEMS? Should I call TIB_Query's Refresh method ? Or is there another way ?

TIA
HJ


[Non-text portions of this message have been removed]