I want to join bo1 to bo2 to bo3 etc based on multipart key values ... I think this would be equivalent to creating a 'view' for the selected data files.  Can I create a business object based on a select statement with this criteria in the "where" clause?

I am using Oracle data for this project.  I will ultimately need to relate (join) between 7 or 8 oracle data tables to get all the various pieces of information that I need for a report.  I am doing a basic 'inner join' where I want the multipart key values to exist in both of the joined files.  Would I have to try to set up multiple sets of parent-child relations for the business objects?

I have set up similiar relationships in the VS2005 'data sets' where I have defined multiple 'data tables' within a single data set.  I have not found any reference on how to do this with business objects.  I have also done the SQL Select statement in VS2005 to populate a single data table within a data set with the desired combination of data fields from multiple data tables based on the matching multipart keys.  I have not found any reference on how to do this with busines objects.

I currently have my multiple business objects set up within my VS2005 project with each business object associated with a single Oracle data table from the corporate database.  What do I do next?

Thanks for any references or examples that you can give me.