Jose,
>The problem is that when the Refresh() method of the second page is executed both AttentionMainBizObj and AttentionMainFaxBizObj are requeried and when AttentionMainFaxBizObj is requeried VFP is trying to insert this new record (Insert trigger is triggered) and the insertion fails since the "Attention" table is not updated yet.
>What am I doing wrong ?
It sounds as if you have set the page 2 business object's nRequeryType to a value other than 0. I recommend setting it to zero and manually requerying the business objects yourself.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com