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"  wrote in message 
news:1186091213.842786.229990@q3g2000prf.googlegroups.com...

> 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"  wrote in message 
news:1186091213.842786.229990@q3g2000prf.googlegroups.com...

> 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?
>