DataSet one-to-one link relation of tables

Question

Hi all,

In an access database I have a member table and a category table. The member table contains a categoryid field that relates to the categoryid field in the category table. I want to grab the categoryname field associated with the categoryid field from the category table and enter it into the member table. I want to do this because i want to display the resulting dataset in a datagridview control, and don't want the user seeing id fields, but rather the actual category. Ideally then I would like to make the category column in the datagridview control be able to have a dropdown menu on each cell where the user can change the category.

Is there any way of doing this?

Thanks in advance,

Max