Populating a Textbox?

[Tyecom]

Hi,

I am creating a simple movie database that will allow me to search for movies. I'm using VB.Net and SQL Server 2005. On my form I have a ComboBox and a TextBox. The ComboBox is being populated with the Movie Titles and the TextBox "should be" populated with the corresponding MovieID number. I can't figure how to populate the TexBox with the MovieID number. All this information is coming from my Movie Database.

Also, even though the Movie are listed, that's all it does is list them. When clicking on the movie title nothing happens. Of course, when I click or highlight the title, the TextBox should be populated with the Movie ID number. Any help would be greatly appreciated.

Thanks in advance.

 

[cjard]

Bind the textbox and the combo through the same bindingsource. If this makes no sense, post your DB and I'll make an example project. Also, please post questions like this in either ADO.NET (perferably) or Data Access

 

[Tyecom]

Thanks Cjard,

I'll try it and will let you know. Sorry for posting in wrong forum. I'll be more alert next time.

 

[Tyecom]

The DB is named "MovieSample". It has two tables (Movies and Description). The Movie has two columns "IdMovie and MovieName". The Description table has two columns "DescriptionId and Description.

Can you please forware an example. Thanks!