THANK U FOR YOUR HELP.

My another question is, I use following statement to append the record on temp table into my main table after doing some selection. But problem is, when I use following statement :

mfile = sys(6)
CREAT TABLE &mfile ...
.
.
.
insert into maintable (a, b, c) ;
value (mfile.a,mfile.b,mfile.c)


The vfp cannot accept the insert statement because it don't know mfile.a ..

How can I solve it??

Thank u.