Sorry, I don’t think I made myself clear enough in my initial post. Here is a sample scenario of what I am trying to accomplish using the Northwind database.
I have a Products form, which shows one record from the Products table at a time. The form contains navigation buttons so the user can scroll through the records in the Products table. I have bound each control on the form to the data set that contains the data from the Products table. The code that I used to bind looks like this:
txtProductID.DataBindings.Add("Text", MyDataSet.Tables("Products"), "ProductID")
For the SupplierID field, I would like to have a combo box display the CompanyName from the Suppliers table instead of the SupplierID. I have created a ComboBoxBase which is bound to a GridListControl. The GridListControl shows all columns from the Suppleirs table.
How do I bind the combo box to the Products table so when user navigates through the records in the Products tale, the correct CompanyName displays in the combo box? I have attached a sample so you can see what I have done so far.
Thanks,
Chad
ProductsDataBindingSample.zip