Any idea why this isn't updating. Code is in Before Record Updated? I think it should be really simple, but can't work it out!
All I want to do is check if there is a value in the record being updated and if so, update another table??
The alert shows!
if($values['quoted_price_pw']<>""){
$sql = "UPDATE quote_request SET status_id='2' WHERE ID='".$values['quote_id']."'";
CustomQuery($sql);
echo "<script>alert('hello');</script>";
}
return true;