TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
0
)
Import Excel file to Access DB on remote server
TableAdapters And TransactionScope