Oh, yah, I got your point, but my problem I can't use the .SelectedIndex more that one in the form using databin, it gives me an error. see this what I did:

' ComboBox Datasource
Me.cbNationality.DataSource = myDS.Tables("Nat")
Me.cbNationality.DisplayMember = "Nationality_e"

' Then Binding CB to the other table "Members"
Me.cbNationality.DataBindings.Add("SelectedIndex", myDS.Tables("Member"), "Nationality")

Error:
Additional information: Specified argument was out of the range of valid values.




>Ahmad,
>
>>>So, how databinding will know that value "3" in "Nationality" filed in "Members" table belongs to value "3" in "Code" PK field & "Nat_Name" field in "Nationality" table ?
>
>Why? Because, that's how ComboBoxes work!! You're binding to the column in the "Members" table that has the code in it, and the DataSource for your ComboBox is the "Nationality" table. Am I missing something or are you?
>
>~~Bonnie
>
>
>>How are u Bonnie...
>>
>>Neither !!!
>>So, how databinding will know that value "3" in "Nationality" filed in "Members" table belongs to value "3" in "Code" PK field & "Nat_Name" field in "Nationality" table ?
>>
>>What forces the "Nationality" DataSet to skip to that row ?!!
>>
>>Thanks again....
>>
>>
>>>Ahmad,
>>>
>>>>>Should I make a DataRelation between 2 tables, OR
>>>>>Use .Find method every time the user clickes “Next” or “Back” button to display member information?
>>>
>>>Neither ... all you have to do is data bind your ComboBox to the "code" column in the "members" table.
>>>
>>>~~Bonnie
>>>
>>>
>>>
>>>>Dear All,
>>>>
>>>>I have window form displays all members basic information, & members data saved to members table, One of these information is for member nationality (as a ComboBox in the form).
>>>>
>>>>Nationality list are in a separate table with only “nationality” and “Code” fields & “Code” as PK.
>>>>
>>>>In members table only nationality “Code” is stored.
>>>>
>>>>Now, when I display the members data, nationality combobox should point to the correct code in the nationality table.
>>>>
>>>>Should I make a DataRelation between 2 tables, OR
>>>>Use .Find method every time the user clickes “Next” or “Back” button to display member information?
>>>>
>>>>Note:
>>>>I have 5 combobox’s in the member form uses the above method of displaying the data based on master tables.
>>>>
>>>>Thanks for the advice.