Now, I want to populate a grid from a BO that has custom properties.  No big deal.  All is well there, too.

Except, any foreign key fields will not pull data from the appropriate table (BO) reference.  This has probably been asked before, but after reading about a dozen threads on the issue, I am no further to getting a solution than when I started.  Thus, I post.

Here goes...

I have a table with, say, three fields:  colIndex (PK), colDesc, colStatus (FK).
In addition, as declared in the BO, I have a custom property: myCustomProp.

I want to fill a grid with the following:  colDesc, colStatusDesc, myCustomProp.

Please note that colStatusDesc is a field from the foreign table that is related to the main table. 

I cannot create a view, since the custom properties do not exist within the RDBMS.  If I just use the base BO, I do not have access to the foreign table's description field.  Or, do I?

Now, this is a very simplistic example.  My actual grid has several of these foreign key thingies (length unit, inventory unit, statuses, divisions, etc.; also several custom properties, too).  I cannot have parent-child BOs handling all of these relationships.  At least, I do not know of a way in SF to do this.

So, what do I do?

Thanks for any help on this!
Bill