>Hi,
>
>I have temporary BO to allow user to edit records which is in un-normalized format. Then, I want to add these records back to normalized table - ParentTable and ChildTable.
>
>After saved,User may want retrieve and edit/delete records in this temporary BO. Any simple way to "merge" back the records to database?
>
>Thank you
Sounds like you need a view (SQL Server, not VFP) where the update is happening to the child rows.
Or you need a collection of collections :) Where oSalesOrder has n Number of oOrderLines.