I have a combo box and a grid on the windows form. I have the grid
populated with data from a query with on simple join to show the user
friendly description of the ID that is in the table. When I click on
one row of the grid, I will show the value in the combo box. When the
user changes the value of the combo box, I want to have that value
reflected in the appropriate column in the grid. When the user is done
making the changes, a button will be pressed to commit all of the
changes to the database. Just so you know, in grid editing is out of
the question for this project. The standard is to have a seperate combo
box to do all of the editing. What is the best way of going about this?
I currently have it set up so that the grid is bound to a dataset
containing all of the information with the join query. I looked into
having a dataset with two datatables with a datarelation, but then the
grid will not display the way I want it to. I dont see an easy way to
display the unique values in the combo box without binding it to its
own dataset, then manually finding the record in the other dataset and
updating the appropriate column. I dont mind doing that, but I want to
know if there is a better method.

thanks!