|
To update two joined
tables use the following code in Add
page: Before record added and/or Edit page: Before record
updated events.
 Note: Change
the values listed in red to
match your specific needs.
|
global $conn;
$sql = "update othertable set joinedfield=".$values["joinedfield"]." ... ";
db_exec($sql,$conn);
unset($values["joinedfield"]);
|
To update master and details
tables use the following code for details table in
Add page: Before record added
and/or Edit page: Before record
updated events.
|
global $dal;
$tblDetail = $dal->Table("DetailTableName");
$tblDetail->Value["Field1"] = $values["Field1"];
$tblDetail->Param["OrderID"] = $values["OrderID"];
$tblDetail->Update();
unset($values["Field1"]);
|
Field1 is a field in the
detail table and OrderID is
the linked field in the master table.
For more information about using Data Access Layer (DAL), see
Data Access Layer.
|
