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