>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
Edward Pikman
Independent Consultant