Master / Detail

In the "Before record updated" event, check if the field values of detail records are closed. Here it is similar code: http://xlinesoft.com/phprunner/docs/before_deleting_a_record_check_if_related_records_exist.htm

Hi Christian,
I use this code now to check if my query is correct but it gives me always true.. Maybe you see why?
I have made 2 rows in the header, i activated 1 checkbox to checked and one is not checked. It still gives me true

If i make the checkboxes of the 2 rows unchecked it still gives me true.
I think it does not check the complete array, do you see the problem?
function BeforeEdit($values,$where,$oldvalues,$keys,$message,$inline,$pageObject)
global $dal;

$tblOrder = $dal->Table("header");

$rs = $tblOrder->Query("PlanID=".$oldvalues["aanmeldnum"],"");

$data = db_fetch_array($rs);
if($data["Done"]==0) {

echo "<script>alert('FALSE')</script>";

return false;
}

else {

echo "<script>alert('TRUE')</script>";
return true;

}

I'm assuming the query below returns more than one result:

This was it Christian,
I understand whats went wrong now.
Thank you very much for your expertise!
Regards Ivan

Hi Christian,
Maybe i can ask you a question about this?
And when there is no result? so no rows in my header?
Kind Regards,