>>Hi everybody,
>>
>>In my form I have a combobox and bellow a grid in which I try to show related table's descrip. Now, when I add a new record, the new description is not shown.
>>
>>Here is a code I try in the combo's InteractiveChange event
>>

>>thisform.cntButtons.cmdAdd.Enabled = .t.
>>SELECT SCSGLink
>>SET RELATION TO
>>SET RELATION TO group_no INTO csrGroups

>>
>>Should I try to switch to using iif(seek(...), ...,...) expression as the column's source for the grid instead of current RelatedTable.Descrip ?
>>
>>Thanks in advance.
>
>Why not filtered View or CA?

I'm using an analogue of the remote view. I get the main table using SQLExec and then set several properties to make it updatable. Our program that makes the view updatable doesn't allow extra fields from another table. I once tried to change that program and allow extra fields, but it didn't work. So, that's the limitation - I can only use a view based on the original table and can not add extra fields.

This leaves me with the relation or the other idea I'm trying right now.