Combobox that display data from ITS OWN TABLE

[crystalelle]

Hi,

I am working on a project.

I am using combobox on my project which I drag from a field in the sql table. I am using a sales order table for this.

I want user to be able to click the salesorderid combobox and the data display is from salesorderid field. When user choose one salesorderid it will display all the information of this salesorder in other control that i have drag into the same form. How do I do it?

Please help.

[jmcilhinney]

When you dragged your field it should have created a BindingSource, to which the ComboBox is bound. You can add other controls, like TextBoxes, and bind them to the same BindingSource. I'm not sure whether dragging another column from the same table would create a new BindingSource or use the existing one but if you bind the control manually it will work for sure. You would create the binding from the Data section of the Properties window.

[crystalelle]

I have combobox which bind to other table. It acts as users multiple selection. Work perfectly.

However to bind it back to its own table it still run but the data provided is data.view.grid instead of the data in the table itself.