Hello,

I have a simple DataGrid displaying data in my DataSet, which is loaded in
two DataAdapters.

It works fine where I fill the DataSet using the DataAdapters.  It displays
the data, can be updated, etc.

Now here's the question.

I have a simple PK/FK relation between the tables, and I was hoping to use
the design tools to easily create this relation.

In design time, I apparently need to manually define the tables in the
tables collection and create the relation in the relations collection.  Is
there an easier way to load the DataAdapter definitions into the dataset
during design time, so I can easily create the PK/FK constraint?

Also, what is the easiest way to create a dropdown list in the datagrid for
the FK table?

Thanks,

eric