hi all,

i need to quick search via name at my table(more than 6 milion records)

i have fields name1,name2,name3,nam4,

i need to search name1
or name1 + nam2
or name1 + name2+name3
or name1 +name2 +name3 +name4

or name2
name2+name3
or name2+name3+name4


or name3
or......etc


i try it as
1. i made index as index on name1+name2+name3+nam4 tag any name????

2.

at thisform.text3.value..event ineractivechange
if LEN(ALLTRIM(thisform.text3.value)) >= 3
        * set step on
 
 SELECT name1,name2,name3,name4 from med;  
        where  atc(trim(thisform.text3.value) ,name1)>0 ; 
         ORDER by name1; 
          into cursor crsMyCursor
         
          thisform.Grid1.RecordSource="crsMyCursor"
          thisform.grid1.Visible=.t.
<pre>
**event ineractivechange
 if LEN(ALLTRIM(thisform.text3.value)) >= 3 AND LEN(ALLTRIM(thisform.text19.value)) >= 3
       
 SELECT name1,name2,name3,name4 from med;  
        where  atc(trim(thisform.text3.value) ,name1)>0 or atc(trim(thisform.text19.value) ,name2)>0; 
         ORDER by name1,name2; 
          into cursor crsMyCursor
         
          thisform.Grid1.RecordSource="crsMyCursor"
          thisform.grid1.Visible=.t.

.
.
.
.

thank