>Ok, this is getting silly. Here's what I'm "trying" to do.
>
>I've created a view, VendorView, which consists of my codes.dbf (lookup display values for use with my tables) with a filter of " codetype='vendor' " so I have a collection of only my vendor codes/display values.
>
>I then created a view, NetworkView, which links a data table, Networks.dbf, containing the following fields:
>
> nid ... primary key
> product... text field
> vendorcode...code for vendor display value from codes.dbf
> numunits ... number field
>
>with my VendorView so I get the display values for my Networks.vendorcode values. On the Update Criteria page of View Designer, I have Networks.nid as the key field, and Networks.product, .vendorcode, and .numunits as updatable fields. The "Send SQL updates" box is checked, SQL WHERE is the default "Key and modified fields", and "Update using" is also the default "SQL UPDATE" option.
>
>I now want to use VendorView as my data source for my Networks grid on a form. I have 3 columns:
> Column1 ... Products (order set on this field)
> Column2 ... Vendor (display value for Networks.vendorcode)
> Column3 ... Number of Units (numunits value)
>
>Column2 contains a combobox control so my users can pick a vendor from a list. I need to display the codes.dbf display value, but save the user's changes to Networks.vendorcode field for the appropriate record.
>
>I can't figure out how to do this without some awkward and probably inefficient coding. And I can't find documentation re: using views as grid sources with comboboxes.
>
>Any words of wisdom out there??? I'm sure this isn't that complex is I knew what I was doing :^)! Any help would be ***incredibly*** appreciated!
>
>Mandy
Mandy,
I don't really know if I fully understand your problem (it's a little confusing to me) but what did you set for the combobox's Controlsource and BoundColumn property? Based on what your Recordsource for the combobox is, it seems like you need to set the BoundColumn to ???.vendorcode and Controlsource to Networks.vendorcode and it should work.
HTH
John.
It's "my" world. You're just living in it.