DataRelation problem

[JontyMC]

I have dataset with two tables:

Employee: ID, Name, CompanyID
Company: ID, CompanyName

I set up datarelation Employee.CompanyID/CompanyID.

Now I set datasource of my datagrid to dataset.employee.

My datagrid displays:

ID - Name - CompanyID
+ Company: ID - CompanyName

How can I get it to display the columns I want (with no drill down):

ID - Name - CompanyName

(In SQL, I would do "SELECT ID, Name, CompanyName FROM Employee INNER JOIN Company ON Employee.CompanyID = Company.ID")

Jon

"I don't regret this, but I both rue and lament it.

 

[JontyMC]

I answered my own question:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319076

Jon

"I don't regret this, but I both rue and lament it.