|
|
Show data from master table on detail view/edit/add page.
To add this event use 
(Insert PHP code
snippet) button on the Visual Editor page.
 Note: Change the values listed in
red to match your specific needs.
global $dal, $strTableName;
echo "Master Info<br>";
if ($_SESSION[$strTableName."_masterkey1"])
{
$rs = $dal->MasterTableName->Query("Masterkey=".$_SESSION[$strTableName."_masterkey1"],"");
if ($data = db_fetch_array($rs))
{
echo "Field1: ".$data["Field1"]."<br>";
echo "Field2: ".$data["Field2"]."<br>";
}
}
|
For example, Orders is
a master table, while Order
details is a details.
global $dal, $strTableName;
echo "Order Info<br>";
if ($_SESSION[$strTableName."_masterkey1"])
{
$rs = $dal->Orders->Query("OrderID=".$_SESSION[$strTableName."_masterkey1"],"");
if ($data = db_fetch_array($rs))
{
echo "Customer: ".$data["CustomerID"]."<br>";
echo "Employee: ".$data["EmployeeID"]."<br>";
}
}
|
|
