Hi again Raj,

I am sorry, but my code is buried deep inside much other code, so my actual code is of no value. But I will give you a head start with some untested semicode:

lnFile=adir(temp,'somefile*.dbf')
create cursor result (fielda c(25),fieldb i, sourcefile n(1))
index on fielda tag fielda && or whatever index you want
for x=1 to lnFile
  select fielda,fieldb,lnFile as sourcefile from ('somefile'+ltrim(str(lnFile))) where YOURCONDITION into cursor tempcursor
  select result
  append from tempcursor
endfor
select result

Good luck!

>Tore,
>
>You are right, I need to partition the tables to something1, something2, something3.
>And the search results(From something1, something2, something3), i will append to the cursor.
>
>And show the results in the grid.
>
>By any chance Tore,do you have the code where you make the search from 3 tables and append results to the cursor.
>
>Thank you.