If you want a temporary index, you have many choices:

1) INDEX ON MyField TO IDXFile doesn't need exclusive use

2) SELECT * FROM MyTable INTO CURSOR curTemp
INDEX ON MyField TAG MyField (VFP will delete the index at the same time the cursor is closed)

3) Same as 2), but with a view

HTH

>In testing, I found that I had to have exclusive use of the table to execute the index instruction - something that I can't guarantee at runtime. I'll just have to manually add the index to the table structure. I was hoping I could create a temporary index at runtime for this particular task.