hi
try this
local procedure InsertSyncTableLoop()
var
SourceTable: Record SourceTable;
SyncTable: Record "Sync Table";
begin
if SourceTable.FindFirst() then
repeat
SyncTable.Init();
SyncTable."Primary Key" := SourceTable."Primary Key";
SyncTable.D1 := SourceTable.S1;
SyncTable.D2 := SourceTable.S2;
SyncTable.D3 := SourceTable.S3;
SyncTable.Insert();
until SourceTable.next = 0;
end;
check my answer if it helped you, thanks
DAniele
