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.

I actually have breaks in Clients_CurrentDataTableRefilled, Navigating, and Navigated.  None of these are hit in between the primary BO events I talked about.  They are hit before that and the values are correct at that point, but between the CurrentDataTableRefilled and Navigating of the primary BO the row count value changes.

If you have the SF source code built in debug, you can put a breakpoint in the BusinessLayer.vb file somewhere around 2109 or 2110 which should be the ChangeCurrentDataTable() method.  It should get hit when the table is refilled or cleared (when a Clear() is called).  You might give that a try...