datagrid from two table in a dataset

[ysommer]

Hi,
I would like to know if anyone has an idea how solve this:
I am loading an xml file to a dataset that contains more than one table. I defined the relationship and I want to present on a datagrid the information in a flat way instead of a parent/child way. Its very easy to do in Access or SQL Server but I can't find a way to it from a dataset.

For Example,
Client Name Company
----------- -------
Joe Schmo ABC

Instead of
Client Name
-----------
+ Joe Schmo
Company
-------
ABC

Thanks,
Yoel