>>>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
>
>I was actually thinking about it too, but what exactly do you mean here by calculated columns? Something like LOOKUP...? Would it require an access to the table all the time?
>
>Or can you please expand your idea?
>
>Thanks a lot in advance.
Check functions like ascan(), seek()...
Cetin