Shaped table names

Hi everyone,

I am loading data into a DataSet using the MSDataShape provider, and I need
to control table that the child data gets loaded into. For example, I load a
schema that creates (inferrs) a ReportGroups table (the parent) and a
Reports table (the child). When I use the following shape command

SHAPE { SELECT * FROM ReportGroups} As ReportGroups
APPEND ({ SELECT * FROM Reports } AS Reports RELATE ReportGroupID TO
ReportGroupID) AS Reports

and call

oAdapter.Fill(oDataSet, "ReportGroups")

the parent data gets loaded into the ReportGroups table properly, but
instead of loading the child data into the Reports table, the DataSet
creates a third table called ReportGroupsReport (concats the parent and
child table names together). How can I tell the DataSet to load the child
data into the correct table? Is there an easier way of doing this?

Thanks,
Bob L.