Hi,

Is there a way to join a table with all its lookup value tables without using a Join statement in the business object?

Our datamodel has a lot of lookup tables (read: extremely normalised) and I need a good solution for how these are handeled. For example if an Order has and OrderType lookup as well as OrderItems child table, how would you organise the Order and OrderType tables into business object(s).

At the moment the idea is to use SQL Join to join a business object's main table (Order)to all its lookup tables (OrderType) but the sql statements would be huge since there are a lot of these lookup tables and I am afraid that it would become unmanageable.

Thank you in advance,

Andrew