Update multiple tables

To update two joined tables, use the following code in the Add page: Before record added and/or Edit page: Before record updated events.

$sql = "update othertable set joinedfield=".$values["joinedfield"]." ... ";
db_exec($sql);
unset($values["joinedfield"]);

To update master and details tables, use the following code for the details table in the Add page: Before record added and/or Edit page: Before record updated events:

$fieldValues = array();
$keyValues = array();
$fieldValues["Field1"] = $values["Field1"];
$keyValues["OrderID"] = $values["OrderID"];
DB::Update("DetailTable", $fieldValues, $keyValues);
unset($values["Field1"]);
return true;

"Field1" is a field in the details table and "OrderID" is the linked field in the master table.

See also:

•Database API

•Database API: DB::Exec

•Master-details relationship between tables

•Update multiple records on the List page