hi,
i'll try to change but i get error message(syntax error),

how i can insert a fields i choice as char1,char2....,and if i want insert all field becuse
fields at table1=fields at table2.

USE Toto IN 0

FOR I = 1 TO THISFORM.Test8.Value
 *  INSERT INTO Toto (<Field list>) VALUES (<Fields from Newamar66>)
    INSERT INTO Toto (char1,char2,char3) VALUES (char1,char2,char3 from Newamar66)
    INSERT INTO Toto (all fields) VALUES (allfields from Newamar66)

thanks.

regards.
m.qasem