I would like to present a grid of data with two child relationships, using three bands, a parent band and two children. Can this be done? Here is how I would like it to look:

Case ID       Contact         Date
1111            John Doe      8/13/09
     Call ID    Contact   Problem
         1         Caller1     I have a problem
         2         Caller2     I still have a problem
    Unit ID    Serial #    Model #
        1           123456   JXY12
        2           123456   JXY12

As you can see there are three tables: tblCases, tblCalls and tblUnits. tblCalls and tblUnits are both children tables of tblCases. I would like to display them as such in my GridView.

Any ideas? I have tried just adding another SQL command, doing a fill and adding a second relationship using Relations.Add, but I can only get the first two bands to work. The third band never populates.

Any help is much appreciated!
Shayne