Tony,
>There's the problem, why would the first record in the Pur_item table have it's ReqId changed?
I don't see anything that's obvious...I'll contact you off line and see about getting on your machine to take a look.
Best 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