>Hi,
>Thank you for your detailed explanation.
>Since we usually normalized our table, therefore we may need to access more than one table to get certain information.
>Which way you feel should be?
>1. SELECT ... JOIN all these table to view/ADO and access it from a SINGLE data object
>
>2. or each table may have ONE data object and BO will call the approriate data object one by one to get the PK/FK, then pass to another dataobject and ....?
>
John,
That's exactly the type of decision you have to make not me or anyone else. You know how you code, you know what you know and can deal with so design your data access the way you want it.