hi,

thank you very much,

wow it's amazing,it's like a magic.

ok, i want to copy the records not deleted to new table after delete command.

DELETE IN ali123 NOOPTIMIZE FOR LOOKUP(ali.CHAR3,Char3,ali.CHAR3)==Char3
copy file ali123.dbf to (thisform.text1.value)....it's possible.

thanks again.
best regards.