SET RELATION TO Key INTO Table2 ADDITIVEIf You Don't
SET RELATION TO Key INTO Table2 && noting elseabout the Key, no That is no Primary Key, That is field on what theese two tables correspond each other and YES You must have an index (not necessary to be PRIMARY)
CREATE CURSOR Table1 (Id C(10), Field1 C(20), Field2 C(20)) CREATE CURSOR Table2 (Id1 C(10), Field1 C(20), Field2 C(20), Field3 N(15,2)) tosmall = 0 FOR nCikle = 1 TO 300 IF nCikle < 151 INSERT INTO Table1 VALUES (TRANSFORM(nCikle), "Record"+TRANSFORM(nCikle), "Other"+TRANSFORM(nCikle+5)) ENDIF IF nCikle < 160 to_replace = nCikle ELSE to_replace = nCikle - tosmall tosmall = tosmall + 1 ENDIF INSERT INTO Table2 VALUES (TRANSFORM(to_replace), SYS(2015), SYS(2015), nCikle) ENDFOR SELECT Table1 INDEX ON Id TAG Table1 SELECT Table2 GO TOP BROWSE NORMAL SET RELATION TO Id1 INTO Table1 REPLACE ALL Field1 WITH Table1.Field1,; Field2 WITH Table1.Field2,; Field3 WITH Table1.Field3; FOR .NOT. EMPTY(Table1.Id) && Just in case You have no matching records SET RELATION OFF GO TOP BROWSE NORMAL