>>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.
If it's not broken, fix it until it is.
My Blog