copy records to different table

Use a formula:

–––
let myNewRecord := create 'Second Table';
let myA := 'a field';
myNewRecord.'a field' := myA;
let myB := 'a second field';
myNewRecord.'a second field' := myB;
let myC := 'a third field';
[...]
–––

Birger

This code cannot work for multiple records. It returns multiple results unless I use the FIRST to look for the first record.

I had to create my own internal ID then look for the first record. Then incrementally it goes through the internal ID and copies all the records from that table. The only problem is if you delete a record and the ID has a gap in it. I would need to link a Record (Id) or something like that. Is there such a thing?