>>>>>>>>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.
Naomi,
Maybe I am missing something here, Can you send me that form and the CA and tables (I am so tired to start all from scratch) I don;t think that is impossible.
1. You must update only ONE table (Products)
2. You must bind Combo to CA ID fields
3. TableUpdate CA.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.