The dataset looks something like this (using parent/child analogy. Each node is a table, not a record)
1) Parent
a. Child 1
b. Child 2
i. Grandchild1
1. Greatgrandchild1
2. Greatgrandchild2
3. Greatgrandchild3
4. Greatgrandchild4
c. Child 3
Basically, I need to only display grandchild1 and its children and hide “parent”, Child 1 and it’s siblings.
So, My grid would only show :
Even though there are other tables up the chain.
Thanks,
Tony
Got it.
Instead of pointing to the dataset, which I knew wouldn't work, I'm setting the datasource = relation.ParentTable
something like this:
Me.UltraGrid1.DataSource = ds.Relations(2).ParentTable
The grid picks up the parent table of the relationship, and all of it's children.
This is working well, Thanks!
Hi Tony,
You would have to bind the grid to the GrandChild1 relation and set the position of the Parent and Child CurrencyManagers to the appropriate parents rows.
If you bind the grid to the Parent data, then there's no way to do this.