Max

Max

  • NA
  • 5
  • 0

DataSet one-to-one link relation of tables

Sep 19 2007 10:01 AM
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