hi,
thank you.it works fantastic,i use VFP7.
thanks for DEBUG steps.

best regards.
m.qasem

>What VFP You Use to see this error? If You use VFP 6.0 change RecNo("NewDnc") WITH STR(RecNo("NewDnc"))
>
>Mohammed, did You ever Use a DEBUG to see what happens? Open debug, set a BreakPoint on Locate & see WHY it replace only one record, from a distance it is more difficult to see what happens. Change to this code & see what happens:
>
>

>    select 0
>    use newdnc1
>    select 0
>    use newdnc
>    SCAN
>        SCATTER MEMVAR
>        m.tablechar1=NewDnc.Char1
>        SELECT NewDnc1
>        SCAN FOR Char1 == m.tablechar1
>             GATHER MEMVAR
>        ENDSCAN
>        SELECT NewDnc
>    ENDSCAN
>   CLOSE ALL
>