Hi all,

i try to see result at mygrid , but it is very slow operation,

f1=national number
f4=my file number as 00123/234

at my grid i must see all records have the same file number

USE x2
INDEX on f4 TO kk
LOCATE fOR f1=ALLTRIM(thisform.text1.value)
IF FOUND()

thisform.text2.value=f4
SELECT f1,f2,f3,f5,f6 FROM x2 WHERE f4=(thisform.text2.value);
order BY f5;
into CURSOR mycur
COUNT TO s
thisform.grid1.RecordSource="mycur"

ELSE
MESSAGEBOX("not found")
ENDIF

thanks