Jim,
Are you sure that NewID() is the cause of the problem?
At any rate, an alternate method is to specify the NewID() default in the *view* rather than the table. This way, when you add a new record, the NewID() is automatically generated at that time.
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