You're right...this is a limitation of transactions in VFP...unfortunatley you have to find "creative" ways to get around this limitation.
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com