Stephen,
>I'm just trying to think out how to pop the second form up and after comming a new transaction in form 1, jumping over to it and doing a requery(), now come over to form 1.>
You can use functionality similar to that found in CFindForm. When your main form instantiates your sub-form, have it pass a reference to itself to the sub-form. You can use VFP's ACTIVATE WINDOW command to jump back and forth between the two forms. For code examples of this, check out CBizObjForm.FindFormActivate(), and the CFindForm.cmdSelect.Click() method.
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