
How do I move a record to another table?
How do I move a record from one table to another?
-
If it is a one time thing and with a limited amount of data, then you can:
1) manually input the data into Table2
or
2) export the record from Table1 and then import the record into Table2
If this is an ongoing task then you can:
1) do step 2 from above
or
2) investigate the create function and possibly the for function.
-
I'm using this code for this task (copy the record to table B and delete the record from table A)
---
let reply := dialog("", "Would you like to continue moving this record to Table B", ["Yes", "No"]);
if reply = "Yes" then
let TempB := (create 'Table B');
let myT := Text;
let myN := Number;
TempB.(Text := myT);
TempB.(Number := myN);
delete this;
openRecord(TempB);
alert("Record moved successfully")
end---
Examine the code and change field names accordingly.