Combobox that display data from ITS OWN TABLE

[crystalelle]

I am working on a project that need to make combobox as search.

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.

 

[cjard]

Master-Detail relationship. Read the "Displaying Related Data" section of the DW2 link in my signature