Hello Mohammed,

I don't exactly what you want achieve, but if you want generate some random numbers you can use the following foxpro function :

rand() && Look in help for more info about this function.

For example if you want to get a random number between "1" and "the total of records in the table moh11", you can use something like this :

RAND(-1)
USE moh11
COPY TO newmoh111 NEXT  INT(RECCOUNT()*RAND()) + 1

HTH,
Zakaria al Azhar


>hi all,
>i want to insert to mynewtable total of records randomly
>as
>thisform.text1.value=778
>my code under copy this records but not randomly
>any idea.
>

>USE moh11
>COPY TO newmoh111 NEXT  (thisform.text1.value)
>

>thanks.
>m.qasem