Bob,
>I have a MMform that can add new or update a record. When I add a record, the ID value in the ID table is being changed upon entry and exit. What have I not checked?>
Something's definitely awry...I recommend placing a breakpoint in the associated business object's OnNew() method to see if it's getting called twice. If that doesn't work, place a breakpoing in the NewID() stored procedure (located in the database container) to see from where it's getting called!
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