Hi folks,
I would like to ask following question:

I have TIBO_Query with SQL:
SELECT PROJECT.NAME, PROJECT.CUS_ID, CUSTOMER.NAME
FROM PROJECT JOIN CUSTOMER
ON (PROJECT.CUS_ID=CUSTOMER.CUS_ID)

The KeyRelation is PROJECT.

Suppose, that in grid the user clicks on edit button and at the end of the
EditButtonClick procedure the PROJECT.CUS_ID is changed, but the query is
still in Edit mode. Then the CUSTOMER.NAME field in grid shows the old
customer name. Is there any good method to synchronize the record other than
posting it?

Today I have to assign the CUSTOMER.NAME in the extra code. This is simple
example, but when the form show lots of controls related to the customer
(the query is more complex), I need to write lots of extra code to to enable
the user to see the changes before he decides to post the record.
RefreshRecord etc. does not help in this case.

Thanks
Ales Kahanek