Hi,
I am trying to display a description from another file using the key of the Edit form
function EditOnLoad()
{
global $where;
// Parameters:
// $where - string with WHERE clause pointing to record to be edited
//** Check if specific record exists ****
global $conn;
$strSQLExists = "select * from ellipse.msf541 where request_id ='".$where["DA_NUMBER"]."'";$rsExists = db_query($strSQLExists,$conn);
$data=db_fetch_array($rsExists);
if($data)
{
echo $data("SHORT_DESC_1");
}
else
{
echo $where;
}
return true;
//** Custom code ****
// put your custom code here
}
In this case DA_NUMBER is the key field
How do I reference this field ?
I tried $where which does not work.
The echo statement shows : "FORMS"."MSFDE1_ESTIMATE"."DA_NUMBER"='E0007675'
Thanks
