On option 1

• Organize your data into 2 table, the Clients and the Transactions. You could do this with a DataSet with 2 tables and a DataRelation where the Transactions is the child table. Then you set the grid's ViewStyleBand to Horizontal so the transactions appear to the right of the client instead of underneath it. 

If we have 3 tables ( 2 that are supposed to be in a band and 1 parent table. Child band 1 and Child band 2 are not related between them but they have a relation to the parent)  Is there a way to display the 2 bands next to each other?  Example

- parent    child band 1   child band 2

 Because setting the ViewStyleBand to Horizontal makes one band bellow the other like this

parent  child band 1

           child band 2

Thanks Mara 

Hi,

    Oh, I see... no, the grid won't do this on a band-by-band basis.It's all or nothing.

No, that is what I meant when I said "sometimes next to their parents". I want to see the children below their parents, but next to each other.
As in

• widget1
• purchase order #       sales order #
• purchase order #       sales order #
• purchase order #
• widget2
• purchase order #       sales order #
• etcetera