Relational database problem

[mundetas]

I have an access database with to tables. They have a relationship with each other. I have put a combobox in my app. But it displays the Foriegn key id, instead I would like it, to display the text form its primary table. For example in the combobox its '1' but its equals to Ted. I would like the '1' to display Ted instead. Is there a site I go to or can someone please help me.:(

[kvprajapati]

Use DisplayMember & ValueMember properties while binding datasource to combobox.

comboBox1.DataSource = dt;
            comboBox1.DisplayMember = "Title";
            comboBox1.ValueMember = "ID";