Work Order BO
workorderindex (pk)
workorderid
partindex (fk)

Parts BO
partindex (pk)
partnum
unitindex (fk)

Units BO
unitindex (pk)
unitdesc

The grid will display workorderid, partnum, unitdesc.  With only the BOs, their corresponding BBSs and a DevEx Grid, can this be done?  If so, how?

I can easily get the Work Order BO and the Parts BO to display everything I need (employing the appropriate repository controls in the grid).  The Units BO is the kicker.

Hoping someone in the SF community will have run into this issue and will be able to shine some light on this.  Please note that I do not want to resort to SQL script here.  I can certainly create a data query and pass the results to the grid and bypass the BOs altogether.  That is not what I want to do.  I have some custom properties that are showing up in the grid from the Work Order BO that I must have.  These will be lost if I bypass the BOs.

Thanks,
Bill

Please keep in mind that this is an exercise for the use of SF BOs.  If a business object exists, then I should be able to point to its properties.  If one of the properties has a relation to another BO, then I should also be able to point to that second BOs properties, too.  The fundamental question is, can it be done in a grid format, using it as a table-like representation of the data?

Hope I am making myself clear--doesn't sound like it, though.  Holler if anyone needs more clarification.

Bill