>>>>>>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?
>>>>
>>>>There are no where clause. I want the changes in the combobox to be immediatelly reflected in the grid.
>>>
>>>Like?
>>>Filter records according the value of the combo?
>>
>>It looks like I can not use cSoftware, etc. as a result of select (my CA) if I want my changes reflected. I do not see a simple way out of this mess.
>>>>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?
>>
>>There are no where clause. I want the changes in the combobox to be immediatelly reflected in the grid.
>Change SelectCmd to be:
>

>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
>WHERE (?lnSoftware = 0 OR Problems.iSoftware_Code = ?lnSoftware) AND;
>      (?lnHardware = 0 OR Problems.iHardware_Code = ?lnHardware) AND;
>      (?lnOther    = 0 OR Problems.iOther_Code    = ?lnOther)
>

>
>There where you Fill cursor:
>

>STORE 0 TO lnSoftware, lnHardware, lnOther
>CA.CursorFill()
>

>That must bring ALL records from the table
>In each ComboBox InterActiveChange put:
>

>thisform.RefreshGrid()
>

>
>RefreshGrid method:
>

>lnSoftware = EVL(thisform.SoftwareCombo.Value, 0)
>lnHardware = EVL(thisform.HardwareCombo.Value, 0)
>lnOther    = EVL(thisform.OtherCombo.Value, 0)
>CA.CursorRefresh()
>Grid.Refresh()
>

>(not tested)

I see, thanks a lot. Now I'm trying to weigh which idea is easier to implement. Don't forget the Insert case!!! :(