how to correlate business objects against tables

[hazz]

I have a Customer table and an Inquiry table.

I have a few fields in the Customer table which I want to include when I
instantiate and hydrate a business object which I use for business logic and
whose properties update the corresponding table(s) column values at the end
of the method/event.

The Inquiry table has columns Score,Status, DateXXX, DateYYY, etc.
CustomerId is a foreign key in Inquiry.

Is it advised to just add the necessary properties to the 'Inquiry' business
object as the stored procedure gets a few values from the Customer table?
(like email address and phone) Or is there a way to have a separate business
object for the Customer table with the few column-property mappings and link
them viaCustomerID at the business object level? How would I do this? I
don't want to use datasets but I guess that would likr s data relation link.
I think I have heard of someone using a some Parent relation but I am not
familiar with that.

Thanks for any ideas. -hazz

 

[hazz]

ok. so i just took the most practical approach and added properties that
represent data from different tables, all in one business object. Database
queries act as the data distribution system out of and into the
atabase. -hazz