SELECT ncli, COUNT(ncli) AS cnt_ncli, MAX(telno) AS last_telno FROM active ;
   GROUP BY 1 INTO CURSOR telno READWRITE
INDEX ON ncli TAG ncli
SELECT active
SET RELATION to ncli INTO telno
REPLACE ALL active.Count1 WITH telno.cnt_ncli,active.Count2 WITH IIF(active.telno=telno.last_telno,telno.cnt_ncli,0)

>hi,
>thank you for reply,
>it works,
>i need another things ,i want to add the total of tel.lines to another field(count2)
>via code under.
>as..
>

>clint_no(ncli) telno count 1   count 2
>        1      555    3          0
>        1      444    3          0
>        1      666    3          3   this is what i need to add to (mytable.count2)
>
>        2      555    6          0
>        .       .     .          .
>
>        .       .     .          6  this is what i need to add to (mytable.count2)
>
>
>

>
>

>SELECT ncli, COUNT(ncli) AS telno FROM active ;
>   GROUP BY 1 INTO CURSOR telno READWRITE
>INDEX ON ncli TAG ncli
>SELECT active
>SET RELATION to ncli INTO telno
>REPLACE ALL active.Count1 WITH telno.telno
>

>thanks.