Multi column combo data binding

Hi... I am using the Q3 2009 version of your controls and I am trying to understand your data binding.  What I would like to do is to bind the combo to a single field in one table but display a list based on another.   I am just migrating to the telerik controls and .Net and in other ActivieX controls (non telerik) they had two properties that allows me to accomplish this.  They combo boxes had a RowSource and a DataSource.  The model was simple for me to understand.  I would bind the control to the data source but, use the row source for the list.  For the Telerik control I have noticed that it only has the Data source property.  And Until that is set , I cannot set the Value Member or the Display Member properites.
Please can you help me to accomplish this?  Where am I going wrong or not underdstanding

Thank you.

Sorry... I should have perhaps provided an example.  Imagine if you will two tables, One, contains customer orders and and another customers.  The customer orders table contains a Customer ID field as does the customer table. 


I have a form that displays all the customer orders ... all the controls on that form are bound to that table.  I would like to bind the combo box specifically to the customerID on the customerOrders table so it updates that table.  I would however like the list in the dropdown to display the list of customers available in the customers table, displaying the Customer Name but storing the CustomerID. 

My older ActiveX controls seperated the two by having a datasource and a rowsource property.   For me, that was simple to understand.  I have noticed with your .NET controls (I am not sure that this is something common to .NET) doesn't seperate the two and as such I have been struggling to 'figure out' how to accomplish the same task using your Multicolumn combo box.

Please disregard last post.  Your reply was the answer.  Thank you very much for the assist.

Hello,
    I'm trying to do exactly the same, but I use OpenAccess ORM to provide data. I have a BindingSource to binding the form's controls and I set  the BindingSource.DataSource to myContext.MyPersistentClass.getall<MyPersistentClass>(). I'm also trying to change a field of this class, getting it from another Persistent class (another "table"). These two classes/tables have a relationship provide by OpenAccess and implemented by a foreing key constraint in the database.
     I looked up in the links above, but I don't use DataSet, nor DataTable, nor TableAdapter. What can I do?

Thanks.

Hello Iván Tajes,

As my colleague mentioned, the data binding mechanism in windows forms does not support populating one combo box with some data but display different data. Please have a look at the MSDN articles related to data binding. If you want to sort the data you can simply use the sort mechanism provided by OpenAccess. You can read more about this in this documentation article. Another approach is to set the Sorted property of RadComboBox control:

Should you have any further questions, I will be glad to help.

Best wishes,
Svett
the Telerik team