Hi, I want to have a DataGrid with two columns - 1 from one table and
one from another. The tables are linked by a key from the 2nd to the
first. I am using a DataSet in .Net and the tables are in the DataSet
and there is a relationship between that tables in the DataSet. I have
been able to get a column populated with data from one table, but I
don't see how to reference the 2nd table. Is this possible?

Look at the JOIN statement. That should help you do what you need.

"edwardo2005" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi, I want to have a DataGrid with two columns - 1 from one table and
> one from another. The tables are linked by a key from the 2nd to the
> first. I am using a DataSet in .Net and the tables are in the DataSet
> and there is a relationship between that tables in the DataSet. I have
> been able to get a column populated with data from one table, but I
> don't see how to reference the 2nd table. Is this possible?
>

With the dataset and the related tables, you already have most of the
ingredients to do it properly. Use an expression column from the related
table. A join would just screw up your update/insert command objects.

"edwardo2005" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi, I want to have a DataGrid with two columns - 1 from one table and
> one from another. The tables are linked by a key from the 2nd to the
> first. I am using a DataSet in .Net and the tables are in the DataSet
> and there is a relationship between that tables in the DataSet. I have
> been able to get a column populated with data from one table, but I
> don't see how to reference the 2nd table. Is this possible?
>