Hi Alexandre,

Okay, I think I understand, now. But there's no way the grid can alter the structure of your data like this. It seems to me that you need to build your data source so that it returns a single table with the data you want.

The grid will display the data as it gets it from the DataSource.

I'm not a SQL expert, but it looks like you should be able to create a SQL Query that would return a single table with two fields that combine data from both tables and only have to hit the table once.

Hello Mike,

 Ok, i will try to explain with more detail!

I have 2 tables with a relation so i have a hieralquical grid, thats ok!

But what i would like is to join the information that is in the child band in the parant band ex:

Parent Band:  Row 1 Column 1 Value:  ABC

Child Band: Row 1 Column 1 Value: 123

Child Band: Row 2 Column 1 Value: 456

What i would like is only one band with the same information if possible in the same grid:

Row 1 Column 1 Value ABD Column 2 123

Row 2 Column 1 Value ABD Column 2 456

I achive this by creating 2 grids, one is the hierq (1 Dataset and 2 tables) and one with 1 dataset and 1 table. But i have to go 2 times to the database to get the same information of course with diferent views! Than i work with the wingrid.visible to show the grid that the client select with a radio button.

Thaks for the support,

Alexandre