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.