>>The battle continues...
>>
>>Anyone know how would I do the following?
>>
>>I've got a table, "Networks" with the following fields:
>> Product (text)
>> CodeID (code for vendor full name to be used with lookup table's
>> Codes.codeID field)
>> NumUnits (text)
>>
>>I want a grid with 3 columns: Product, Vendor's Display Value (gotten by relating "Networks.dbf " with "Codes.dbf" on their common CodeID value), and Number of Units.
>>
>>I also want a combobox to display when the Vendor's Display Value, (column 2) gets focus and is clicked so my users can choose from a list of vendors to change the value in the grid. The combobox would come from my "Codes.dbf" with a SQL stmt. in the RowSource like...
>> SELECT displayvalue,codeID FROM Codes WHERE codetype='vendor';
>> INTO CURSOR cVendors
>>
>>I can get this far, but when I choose a new vendor in a row/record, I can't get the grid to display the new vendor in the cell or save the change back to the Networks.CodeID field.
>>
>>So basically Column2 displays the Codes.displayvalue for Codes.codeID = Networks.CodeID, and when the value is changed by the user, the new codeID is saved to Networks.CodeID. Make sense? My brain is turning into mush at this point.
>>
>>Also, anyone have a decent explanation of the following Combobox properties: BoundTo, Value, ListIndex? Are they something I should be using?
>>
>>Any help would, as always, be incredibly appreciated.
>>
>>Mandy
>
>Set Combo.Bound=2 to indicate that second field (CodeId) of combo rowsource will be stored in Grid.Column.Controlsource

Sorry, Combo.BoundColumn=2