Can I move items from one table to another?

You can put logic behind a button.. and when on the record click the button that would create a Freezer row.. and delete the Fridge row. 

@Mconneen-sensei, Even though this is possible, it might make more sense design-wise to have a Choice field with Fridge and Freezer options and then filter on that field.

@Sean.... Totally agree...  but answered the question asked.. LOL.. :) 

Sean's way would be interesting with a Kanban view, where you can literally drag things from the fridge to the freezer...

If you still want to move data, use this code behind a button:

let reply := dialog("", "Would you like to continue moving this record to Table B", ["Yes", "No"]);

if reply = "Yes" then

let tempB := (create Table2);

let my1 := Field1;

let my2 := Field2;

tempB.(Field1 := my1);

tempB.(Field2 := my2);

delete this;

openRecord(tempB);

alert("Data moved successfully")

end

You can remove the dialog and alert lines if you want...

+1 on the Kanban view..