local lnNumber, lnFlag
Use yourtable order flag
go top
lnNumber=1
lnFlag=flag
do while !eof()
replace yourfield with lnNumber
skip
if flag=lnFlag
lnNumber=lnNumber+1
else
lnNumber=1
endif
enddo
>my mistake
>
>
>i mean evrey flage have no from 1 to the last records
>
>flag=1 from 1 to 145...replace no with recno() all
>flage=2 from 1 to 450
>flage 3....
>
>.
>.
>.
>falg=9 from 1 to 870 at my table
>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