Gandolf,
thanks for the quick reply, i appreciate it.
when i run the
SELECT "AmountDue" into v_bal FROM PTBAL where "Patient"=:new."Patient" and "Batch"=(SELECT MAX("Batch") FROM ptbalbat);
by itself taking out the into and putting teh actual patient value in it returns a value of 735. so I am not sure why through the app it is not finding data.