the only problem here tore is that i am not using a form to enter name and do the search programmatically - works fine except when you enter EM for example, there are no names starting with EM in the current database but you see 3 names underneath from previous databases (ghosts) that are no longer accessible. That's why i would like to clean these out of the system - but how. is this info stored in tag name1?

k

>Don't even consider an idx, except for cursors. I have used only cdx for roughly 20 years now, and have never had any problems with them. Just create the index tag once, and you're done.
>
>The only thing you must ensure, is that the index expression always create fixed length keys. If this is not a case, you may have strange problems.
>
>>i am used to using idx files - a simple reindex command does the trick.
>>the cdx file has baffled me and i am just guessing on how to control it so bear with me.
>>i have set up auto complete name and find I keep getting old entries appear in my cdx file and wonder if there is a way to clear it out and start fresh.
>>I have tried delete tag name1 - which I assume would clear the old cdx - not so.
>>i am probably way off base but without changing course entirely is there a simple way to do this.
>>thanks
>>k
>>
>>

>>Procedure Load
>>	Select 0
>>	Use myfile.Dbf
>>	INDEX ON vNAME Tag Name1
>>	Set Order To Tag Name1 
>>	Endproc
>>