I am trying to setup a situation that we use a lot and would want to continue using.

Basically, we often bind an Infragistics Ultragrid to a dataset containing 2 or 3 tables. If I bind to a BO then it looks like I am restricted to only one table as the BO itself can only deal with a single table. Is this correct or have I missed something?

Thanks.

Just for clarification, does this technique allow multiple tables to be bound to an UltraGrid in a similar format to the attached screenshot which shows a dataset containing three tables?

If so, will the UltraGrid be able to add new records to any of the tables just as it would if the grid was bound to a three table dataset?

Sorry if this is a stupid question but I don't understand the internal workings of the BBS

Thanks

It will...but like anytime you use a grid, things can get more complicated....especially when using bands.  A grid looks for a IBindingList interface implementation to determine how to bind and interact with the data object to which it is being bound.  So the BBS is just a class that implements the IBindingList interface and exposes the BusinessObject to which it wraps as a unique object (what the IBindingList expects) for each row.  If you are going to get very complicated (as using bands get become) it is sometimes easier to create a class heirarchy that helps you do this.  You can use a BBS and create several exposed BBS properties that expose the children records.  So you would create a BBS class that represents each BO in question, then the parent business object (yes BO not BBS) create a custom property that exposes the child BBS object....like this:

Notice that a filter is applied to the child BO when the Orders property was accessed.  This ensures that only the orders that belong to the current record are visible at this point in time. 

This should at least get you going in the right direction.