What is the best way to structure a Business Object, Customer, that uses data from multiple tables, say BusinessEntity and Address? I gather that a Business Object = 1 table. If this is correct, then I will probably need to get into transactions in order to ensure that adds, deletes, and updates to Customer are consistent in the database.

If I use a view, then should I build the stored procedures in the database for insert, delete, and update, or should I use transactions against the source table in the Business Object?

thanks,

Flavelle