Hi All,
I have the following question about TIB_Grid editing multitable join
results.
suppose there is query

SELECT PROJECT.PRJ_ID, PROJECT.PRJ_NAME, PROJECT.COM_ID,
COMPANY.COM_NAME
FROM PROJECT JOIN COMPANY ON PROJECT.COM_ID=COMPANY.COM_ID
FOR UPDATE

This is to show that this project belongs to some company. The
KeyRelation is set to PROJECT so in TIB_Grid the field COM_NAME
appear grayed and is not allowed to be edited.

In my app I do not want to amuse the users with key values as COM_ID
so its visibility in grid is set to FALSE. The user can assign the
company (internaly PROJECT.COM_ID) by OnEditButtonClick event. I
works fine. But when the user decides to clear the field and let it
blank (company for project is not required), normaly he would clear
the editable PROJECT.COM_ID, but now he can see in grid only the non
editable COM_NAME and cannot clear it (and the PROJECT.COM_ID too).
What is the best way to accomplish this?

Thanks
Ales Kahanek