>>>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.

:o)
My idea was to get SQLEXEC table with parameters and then just REQUERY()it (or this is the same case when you tried to change < < > > to ? in the function?