ADO.NET DataSet woes

[Tim]

Joe,

If the two tables have a relation, then join the two
tables in a query and populate your dataset with the
query, instead of with the data from the tables. Good
luck.

Tim

-----Original Message-----
This is probably really simple, I just haven't figured
out how ADO.NET does it yet.

I have created 2 DataAdapters in Visual Studios .NET C#
from 2 tables in SQL Server related to one another, and
created a DataSet from these 2 tables.

For example:
Table 1: staff_id, type_id
Table 2: type_id, type_name

I want to show the type_name of the currently selected
staff_id.

I have 2 textboxes on a form, one bound to the type_id in
the first table, and the other bound to type_name in the
second.

Is there any way within the Dataset to "bind" these 2
tables together so that moving to the next record in
Table 1 moves to the correct record in Table 2, or do I
have to code this in when the next record is selected?

Thanks for your help,
Joe

.