Good Afternoon Everyone.
I was looking for help on how to copy record data from one table to another. The following example worked great in the events section, but I could not get it to work under a button. Can anyone help me apply this to a button.
//** Save old/new data record in another table ****
global $dal;
$tblUsers = $dal->Table("YOURNEWTABLE");
$tblUsers->Param["ID"]=$values["ID"];//optional for where
$tblUsers->Value["Field1"]=$values["Field1"];
$tblUsers->Value["Field2"]=$values["Field2"];
$tblUsers->Value["Field3"]=$values["Field3"];
$tblUsers->Add();
return true;
// second table should be auto number and this field should not be included above.
Also useful for archive backup recovery....