[RESOLVED] Getting Field Values From a Table Using a Foreign Key

[arcanine]

Try the attached VS2008 demo...

I don't know how to get the attached demo.

Nonetheless, I figured out where to use the INNER JOIN in my project. When viewing a typed dataset in design view, I can click on the table adapter for any table in the dataset, and change the "CommandText" property to include the INNER JOIN you mentioned. VS includes a design time query builder to accomplish this rather easily.

Thanks for nudging me in the right direction!