thanks yes i do. i believe i have gone one more step on this - could the solution be this Al?

Here is the first phase of the program to create automcomplete

Select 0
Use c:\db\students.Dbf
***********************************************
Index On Name Tag Name &&& this invokes and cdx index file
Set Order To Tag Name

Yet before this event occurs i have the following index running

use students
Index on name to name.

I believe the duplicate target is the source of the conflict so i have renamed the tag name1

Index On Name Tag Name1 &&& solution???
Set Order To Tag Name1


k

>>Ok i have finally isolated the problem - all i need now is to find a solution.
>>
>>The CDX is actually the index file that is created when auto-complete is used in one of my menus. Hence the double index - the one i use to sort on name and the one vfp creates to fill in the auto-complete. If i delete it, it creates a new one directly i use the autocomplete feature.
>>
>>Now to the heart of the problem - the error messages we receive are that the cdx is missing - when in fact it is there! We press ignore and the problem goes away - operation is normal. the autocomplete works fine. It does it sparodically. my solution is write a short on error program to ignore error #1707 - but it hardly seems like a dignified solution.
>
>If you have a comprehensive error handler, it can log a lot of information like program call stack, values of variables, open tables/currently selected table etc. You can then examine these log files for clues about what's going on.
>
>If you don't have a comprehensive error handler, you could try Download#29837 (haven't used it myself)