hi all,

i have a table with more than 87000 records,

i have fields(clintno),telno,customer name,....&& not index

i need to to know how many tel.lines for every clint and replace the numbers i count to field(count1) for every tel.line,and replace the count again at another field(count2) as...

first  index mytable via clint_no.

client_no      tel.no    name    count1      total

1              111      aa       5         0
1                221      aa       5          0
1                332      aa       5          0
1                444      aa       5          0
1                555      aa       5          5

2              3321     vvv      7        0 
2                3214     vvv      7          0 
2                6254     vvv      7          0 
2                7894     vvv      7          0 
2                6287     vvv      7          0 
2                2364     vvv      7          0 
2                9687     vvv      7          7

3                .      .       .        .
.                 .      .       .        . 
.
. 

thanks.
m.qasem