I have a BO on my form which uses a few other BOs to get property and the like.  I would like to have properties on my primary BO which point to properties on the secondary BO.  For example if I have a secondary BO called Clients which is linked by the ClientKey on the primary/seconday BO, and want to get the Client Description I would have a property like this:

Public ReadOnly Property ClientDescription as String
  Get
    Return Clients.Description
  End Get
End Property

The question I have is how I keep Clients looking at the right record when I am navigating around in the primary BO.  I fill the Clients BO with all clients in the Fill of the primary BO and I have some code in the Navigated and CurrentDataTableRefilled event handlers to navigate Clients to the correct primary key when the primary BO record changes.  

My problem is that when I get into the Navigated event my Clients.Count is 0.  When it starts the Fill method the Client count is a few hundred, but it clears it out somewhere along the way.  Any idea what I am doing wrong here, or if there is a better way of doing what I'm trying to accomplish?  I can't really use the parent/child relationship here because it doesn't make sense in other areas of the database/code.

Actually, by the time it gets into the Navigating event Clients.Count is already zero.  It is 353 in the PrimaryBO_CurrentDataTableRefilled handler, but then when it goes to the PrimaryBO_Navigating event where I would expect to change where Clients is pointing, the count is back to zero.  I'm just not sure what's happening here...any other ideas anyone?

You might check the CurrentDataTable.Rows.Count and Filter properties to make sure that the records are not being filtered out.  Since the business object navigates off of the CurrentView, it might be that the records are still there, but just not visible for some reason.