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:
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 details table and "OrderID" is the linked field in the master table.
See also:
•Master-details relationship between tables
•Update multiple records on the List page