Hi Sergey,
Thank you for the reply which solved my problem. As usual, your extensive knowledge of VFP has helped us lesser mortals. You know, I was using SET ORDER TO thinking it would make the index go away. Doh!
I also agree with your comments about opening the files in specific work area, however the use of the work area numbers goes back a long way in my app and if I were to do it again, how different it would be. A future project of mine is to change them all to the table alias.... BTW, I was "bitten" by this very same issue with indexes when I was using SET ORDER TO 1 when I should have been using SET ORDER TO TAG numbers (for example).
A lesson well learnt.
Regards...Rex
Rex Toomey
ISD Port Macquarie NSW
Australia
'Inside every older person is a younger person wondering what happened.'