>>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.
If it's not broken, fix it until it is.
My Blog