>>>>>>>Software column should have controlsource='software_code', and combobox within the column should have 2 fields in rowsource (description,code) with combo.boundcolumn=2
>>>>>>
>>>>>>And without using combobox in a grid it would not work? When I change combo's value on the form, would it automatically change in a grid?
>>>>>
>>>>>Sorry, I don't follow. What means 'change in form'? Do you change data in grid.combobox or in some separate form.combobox?
>>>>
>>>>In a separate combobox. My grid is readonly for display purpose only.
>>>
>>>Follow Cetin's advice and use calculated column in grid.
>>
>>BTW, I think the idea of having a separate read-write cursor for the grid is easier to implement and should be better. If, say, I use relationship to show extra info, how would I sort on the column?
>
>You could not do actual sort by description, but you may do it by code. In most cases it is sufficient. If not then you really need to bring description field to the cursor.
I don't exactly get the idea of calculated columns. Borislav's idea of updating cursor in combo's InteractiveChange works very nice for display purpose, but doesn't work for actual saving. Looks like I'm back to square one and closer to my idea of separating the grid and the updatabable fields.
If it's not broken, fix it until it is.
My Blog