I would appreciate help in making sure I understand the concept of how to go about what I want to achieve and would appreciate any input.
Background:using VS2005;using MS Access database;
I have a dataset that has several tables but notably MemberDetails (Name, Address etc) and Titles (TitleDesc eg Mr. Mrs etc). In the dataset I have a relationship with the parent Title.TiltleNumber with the child MemberDetails.TitleNumber.
I have a Windows Form that displays all the member details in textboxes that are each bound to their relative MemberDetails.Field. The form has controls to scroll thru the datatable and show each members details. Works fine BUT!!!
Problem:
How to get the Titles.TitleDesc to display in the textBoxTitleName rather than the MemberDetails.TitleNumber.
Ideas so far:
LookupTableBinding but these don't seem to be able to be bound to a "single cell" control like a textBox. A comboBox is not going to work.Create a temp datatable with all the human readable fields bound to the Windows Form but this seems a little over the top!
How do I do this?
Any suggestions and pointers will be welcomed - references to resources on the net that deal with precisiely what I want to achieve would also be much appreciated.This must have been done countless thousands of times but I just can't come to grips with it!!Thanks in advance.