Pulling multiple Datasets into a Datagrid...

[dwalsh9x]

Hey guys. I'm working on a Flash app and have run into something I'm not familar with yet, but I know is quite simple. I have 3 datasets containing rows of data, and my goal is to pull rows from all 3 datasets into one central datagrid component. Basically the 3 datasets containing inter-related records of data that will combine to form a hierarchy.

The code here is how I'm populating the Datagrid after binding it to a single dataset. I just need to figure out how to somehow pull multiple datasets into this one datagrid to have a "master grid" of data.

on(click) {
    import mx.data.binding.*
    var from:Object = {component: myDataset, property: "dataProvider"};
    var to:Object = {component: myDatagrid, property: "dataProvider"};
    var myBinding:Binding = new Binding(from,to);
}

I'm also going to be doing this with an XML-populated Tree component, which I think is rather straightforward.. but I also want to know if the Datagrid method is possible.

Any ideas? It's going to take some nested loops I'm sure, but I'm just not sure if its possible to pull from 3 differently-structured Datasets into one grid.

Dave