>>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.
>
>At the end I know that you'd decide to make it another way:) Anyway I'd tell my idea for others' benefit. It looks like Software,Hardware,Other are unnecessaily part of it. Instead add them as calculated fields to the grid.
>Cetin

That's absolutely true.