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.