Hey Bonnie,
Thanks for sticking with me here...

My Common project contains my container classes (similar to how you have a DataSets project to hold your DataSets).

My Biz project contains Shared (or Static for you C# peeps) functions to return data-filled classes (after going through my Data project).

My Biz project needs to contain a reference to my Common project so it can return objects of the classes that are contained in the Common project. I wanted to structure my Order class to contain a property of the type of another class, which was dynamically loaded when it was accessed, meaning it had to go back through my Biz project to load.

I think I am going to take your advice and just do the JOIN in my Stored Proc to return the desired field. I waste enough time trying to figure out the best way to do things that I am getting less productive. I think what I need to do is find some sort of local training where somebody fills a mentoring role and I can sit down and go over this stuff. I have always worked alone and haven't had the opportunity to do this.

>So, your Biz class gets the data for the classes/collections in the Common project? I'm still unclear on the architecture of your system. Is it possible for you to give us a brief description of UI-biz-dataaccess architecture?
>
>~~Bonnie
>
>
>>>>It's the way we have our source control system set up. Another project means more of pain with source control and more documentation.
>>>
>>>Oh that's a good one Mike ... letting source control and documentation issues dictate application design. I think this is a first!! <g>
>>
>>I know, I know. It's sad that it has gotten to that point, but it has. I am tired of fighting the corporate battle and my motivation to try to IMPROVE processes is shot, so I just try to make them fit.
>>
>>>
>>>Why can't you just put the Dealerr class in the Common project?
>>
>>That's where it's at. My Order and Dealer classes are both in the common project. However, I am trying to do a lazy load of the Dealer class when I access the Dealer property of the Order class, therefore my Common project needs to reference my Biz project. My Biz class needs to contain an object of my Orders class, therefore my Biz project needs to reference my Commong project. It's a vicious cycle!!!