Here is the code I'm using on my Add Page:After Record Added (which has been modified from some sample code by Jane....THANK YOU).
global $conn;
$message="";
$str = "SELECT
`_customers`.`Customer Type`,
`_customers`.`Customer Name`,
`_customers`.`Company Name`,
`_customers`.`Address 1`,
`_customers`.`Address 2`,
`_customers`.`City`,
`_customers`.`Telephone 1`,
`_customers`.`Telephone 2`,
`_customers`.`Account Number`,
`_jobs`.Job,
`_jobs`.`Action Requested`,
`_jobs`.`Description`
FROM _customers
INNER JOIN `_jobs` ON `_customers`.CustomersID = `_jobs`.CustomersID_FK
WHERE CustomersID=".$values["CustomersID_FK"];
$rs = db_query($str,$conn);
$data = db_fetch_array($rs);
$message.="Customer Type : ".$data["Customer Type"]."\r\n";
$message.="Customer Name : ".$data["Customer Name"]."\r\n";
$message.="Company Name : ".$data["Company Name"]."\r\n";
$message.="Address 1 : ".$data["Address 1"]."\r\n";
$message.="Address 2 : ".$data["Address 2"]."\r\n";
$message.="City : ".$data["City"]."\r\n";
$message.="Telephone : ".$data["Telephone 1"]."\r\n";
$message.="Telephone : ".$data["Telephone 2"]."\r\n";
$message.="Account Number : ".$data["Account Number"]."\r\n";
$message.="\r\n";
$message.="\r\n";
$message.="Job : ".$data["Job"]."\r\n";
$message.="Action Requested : ".$data["Action Requested"]."\r\n";
$message.="Description : ".$data["Description"]."\r\n";
$email="email@address.com";
$subject="New Job : ".$data["Account Number"]." : ".$data["Customer Name"]." : ".$data["Company Name"];
mail($email, $subject, $message);
I would like to have an "Email Job" button on the View page which send out this same exact information to someone based upon tha name selected in the job, and their associated email address in the user table.