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.