>hi all,
>
>i need help to replace at mytable field1 with field2
>i have numbers at field2 , 1,2,3,4,5,6,7,8,9,10,13,16,17,19,20,40,41,42,43,44,54,55,56,57,58,59
>60,61,62,63,64,66,67,68,69,89,90,99
>

>ex..
>field1  field2
>1      1
>2    2345
>3    8765
>4    987
>       2
>1    2672
>2    09876
>3    87654
>4     1287
>       3
>.
>.*****************i need to replce it as
>
>1      1
>1    2345
>1    8765
>1    987
>       2
>2    2672
>2    09876
>2    87654
>2     1287
>       3
>3     7654
>3     3456
>3     7654
>3     3987
>        4
>.       .
>.
>
>

>thanks

lNumber=field1
do while !eof()
   replace field1 with lNumber while {condtion here, maybe field2#lNumber+1 or maybe not isblank(field1)}
   lNumber=lNumber+1
enddo