hi,
it works.thank you,
but i need to insert ex..just 100 records randomly from field="121"; and 180 records randomly from field1="323", via thisform.text8.value etc....
and delete this records from mytable newamar66.
SELECT * FROM newamar66 ;
WHERE char21=thisform.text7.value;
INTO CURSOR tmpAppend
SELECT 0
USE toto
APPEND FROM (DBF('tmpAppend'))
USE IN newamar66
USE IN tmpAppend
thanks.
best regards.
m.qasem