Ok, I have an idea, though I don't really like it. I can not use the same cursor for updating and for grid display, I need an extra cursor for the grid. Every time I made a change in the field, I would make a similar change in this cursor, thus reflected in the grid.

>>Hi everybody,
>>
>>I think I'm in complete mess :( I have a grid on the form to display all records from the table. This grid recordsource is a CA and the selectCMD is
>>

>>select Problems.*,
>>	nvl(Software.cDescription,space(3)) as cSoftware,
>>	nvl(Hardware.cDescription,space(3)) as cHardware,
>>	nvl(Other.cDescription,space(3)) as cOther from problems
>>	left join Software on Problems.iSoftware_Code = Software.iSoftware_Code
>>	left join Hardware on Problems.iHardware_Code = Hardware.iHardware_Code
>>	left join Other on Problems.iOther_Code = Other.iOther_Code
>>

>>
>>Now on the top I have fields (EditBox for the mDescription) and comboboxes for iSoftware_Code, iHardware_Code, etc.
>>
>>My problem is, that I can not change iSoftware_Code. When I change it in the combobox, how can I "refresh" my grid?
>>
>>Is it doable at all or should I start again from scratch?
>>
>>Thanks a lot in advance.
>
>Where is WHERE clause in that CA?
>If you see ALL records from table what you want to happen when something is changes in that CBOs?