Public ReadOnly Property ClientDescription as String Get Return Clients.Description End GetEnd 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.
Your best bet would be to change the child business object to a shared variable so that all instances of your primary BO type have the same reference. Or, you could possibly add the code to populate the child into the Navigated() event of the business object and only bring in the records that match the current primary bo record, but that would greatly increase the number of database queries if you have a lot of parent bo records. Or, you could move the child business object outside of the parent business object and reference it there.