Kevin,
>So I'll paraphrase my question - so long as one is utilizing primary/candidate index definitions in VFP, would you always expect the following to work?
I've seen it be hit or miss...although lately it does seem to work well without too much extra work. You may be on to something regarding the version of the VFP OLEDB provider...
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