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
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)