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.