combobox question

[GS]

I got a detailed view of bound sql dataset table. what is the best ways to
allow user to select values via combobox on some of the table columns?
O know a way of using another table from the same dataset but that requires
me adding extra combo box and event to link the change in the comboboxes
back to the actual table columns to be updated.


I also notice that there is a style of combobox box in the detail table
column in the designer but I don't know how to use that despite searching on
internet and experimentation.

 

[GS]

apparently, if I use the drag and drop the detail table columns as
combobox, it will lead to perfect display but will not validate. leaving me
unable to move between rows after clicking on the combobox.

and if the application check if anything changed, and I will be unable to
save nor cancel edit nor quit the application!

now someone in the windows form mentioned that he use the lockup table as
combobox, drag and drop it onto the form, and set the selectedvalue to the
look up table's code
it worked for him.

I tried but still failed to validate