Frans,

Is it possible to create a typed list with joins where the joins are not in the Entities section? They exist in the Catalog just not in the Entities? Example: I am creating a Lead Business Object from the data layer and I want the same separation in the data layer DLLs for reuse purposes, but I want to create Typed Lists for query purposes to return information from the joins like:

**Lead -> LeadLocation **-> Location

So in my business and Data Layer I want Lead and LeadLocation as Entities in the LEAD dlls. Since Location in used in an address DLL I want the Location Entity to stay with it. My issue is in the Lead Business Layer I want methods like FindLeadsByState or FindLeadsByCounty. The only ways to do this cleanly now is:

1. Create a DB View with the joins
2. Create a Retrieval Stored Proc with the joins
3. Create a dynamic query using the base objects in the DQE

My preferred method would be to VISUALLY create a typed list and not have to hand code the views, stored procs, or DQ.

Any thoughts?

Thanks, Wade

That's not possible at the moment, a typed list is a list based on existing entities in the project, as the typed list uses information defined in these existing entities.