I have a typed dataset which I am populating using fill methods based on stored procedures.
I have a form which contains a summary list of records and when a record is selected the detail of that record opens in another form.
On opening this second form, I am filling the main table of my dataset with the one record I am interested in, but then also filling a number of 'reference' tables, such as users, which relates to the CreatedById in my main table.
I am binding controls on my form to the main table, but I also have some controls that I do not wish to bind to a particular column, but wish to display data from the related user table such as FirstName + Surname etc.
Can someone tell me how I can programatically do the following:-
txtCreatedBy = tblParent.relation.childrecord.fieldvalue
If I bind the text box, I get a list of tables in my dataset, where I can select my main table, then select the foreign key name and then select the fieldname from that relation and this would display that column, but I need to display a combination of columns and they should not be bound, as I do not wish to update them.
Am I going about this the wrong way? Should I be getting one datatable with all the information in that I need to display (including related descriptions) rather than using relations to link to it?
Any help would be greatly appreciated.