USE Toto IN 0 FOR I = 1 TO THISFORM.Test8.Value INSERT INTO Toto (char1,char2,char3) VALUES (Newamar66.char1, Newamar66.char2, Newamar66.char3) * INSERT INTO Toto (all fields) VALUES (allfields from Newamar66) *-- Here you can either specify all the fields like this: INSERT INTO Toto (Char1, Char2, Char3, ...) VALUES (Newamar66.Char1, Newamar66.Char2, Newamar66.Char3, ...) *-- or INSERT INTO Toto VALUES (Newamar66.Char1, Newamar66.Char2, Newamar66.Char3, ...) *-- If the field names are identical, you can use this: SELECT Newamar66 SCATTER NAME oData INSERT INTO Toto FROM NAME oData ENDFORHTH
>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)