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