inserting selection into another table from a dropdownlist

[tonygr]

Hi All,
I originally posted the below in the vb.net forum, but it may be more relevent in this forum, please help.
Hi All,
Can Anybody help, I have a sql_2000 db which has two tables, I am using vs.net2005 (VB.net) as a front end. I have a form with a drop down box on it, populated from table1.centre when the user makes a selection from the drop down list I would like the value selected to go into table2.centre field along with the other details submitted on the form.
I can get the list of values to display but it doesnt seem to populate the table2.centre.
I have probably done it wrong from the outset.
I should also point out that I am a newbie and would greatly appreciate step by step help on this.
although any help or pointers would be a great help.

Yours sincerley
Tony

 

[tonygr]

p.s. I should have added this related info + code.

on the form in design view the when the combo is highlighted it produces a arrow top right, click into this then
tick databinding mode
Data Source = centredescriptionbindingsource
Display Member = centre_description
Value member = Centre_description
selected value = (none)
I then double click the combo box to go to the code and this is what I get relating to the combo

private sub combobox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedndexChanged

End Sub

 

[jbenson001]

In that event, write you code to insert into the table.