hi,
thank you,
i insert at thisform.text7.value="121" or "112"
and thisform.text8.value=15
but i get at toto 15 records with char1="111",i mean different data.

and can i delete from newammar66 the records i put it at toto.

thank you very much.

CLOSE all
SELECT * FROM newamar66 ;
WHERE char21=(thisform.text7.value);
INTO CURSOR tmpAppend

USE Toto IN 0

FOR I = 1 TO THISFORM.text8.Value

    SELECT Newamar66
       SCATTER NAME oData
    INSERT INTO Toto FROM NAME oData
ENDFOR

best regards.
m.qasem