thank you for help and code,

i can do that

via index at my filed
and replace field with rec(no)all

but i need flag =1 have numbers from 1 to last record

flag=2 from 1 to last record

..
..
..

thanks



>>hi all,
>>
>>i have table have more 20000 records
>>
>>have fields as flag from 1 to 9,
>>
>>i need to replace all fields have flage= 1 numbers from 1 to the last record have flage= 1 as ex.. 145
>>
>>flage= 2 take numbers from 146 to end flage=2 as last record is 445
>>
>>flage= 3 from 446...etc
>>
>>thanks
>

>local lnNumber
>Use yourtable order flag
>go top
>lnNumber=1
>scan
>  replace yourfield with lnNumber
>  lnNumber=lnNumber+1
>endsacan