Hope it is OK if I jump in on this topic too as I am not getting it. If I execute the following:

DataSet ds = this.GetDataSet(SQLstring);

I get back a dataset with one table with the default TableName. If I follow that line with:

ds = this.GetDataSet(SQLstring,"MyTable");

I get back a dataset with only one table named "MyTable". The first table is nowhere to be found. Then if I execute:

ds = this.GetCurrentDataSet();

It is confirmed that the default dataset for the biz object contains only the second table.

I am not understanding how to get multiple tables into the default dataset using the standard data retrieval methods.

Thanks!

Del


>
>Rather than creating two different business objects, you can create two different data tables in your business object's DataSet. Although you normally specify the default table in the TableName property, all MM .NET data retrieval methods allow you to specify a different table name into which to store query results. This allows you to use a single business object to retrieve multiple views of data.
>
>Regards,