The scenario is this:

two forms

Materiel in 

& 

Material out 

one report

Materiel on hand 

when material comes in it is 

logged on the "materiel in" form and assigned an Auto_Number

when it goes out it is logged on the "materiel out" form using a lookup field back to "Materiel_In" Auto_number

is there a way on the "materiel on hand" report that i can 

set a Materiel_On_Hand field that is something like 

//Materiel_in.QTY - Materiel_Out.QTY = Materiel_On_Hand 

IF there is a corosponding record in "Materiel out", Else 

"Materiel_on_Hand' == "Materiel_In.QTY

//

//IF Materiel_in.QTY - Materiel_Out.QTY == 0

//Cancel.Submit;

//Notify "No Stock on Hand";

//email.zohoadminID  "Request for zero count item. Reorder item (materiel_In.Auto_Number) (materiel_In.name)";

//IF Materiel_in.QTY - Materiel_Out.QTY == < 0;

//cancel.submit;

//notify "Not enough stock on hand";

// email.zohoadminID "Hey You REally Really Need to order (materiel_In.Auto_Number) (materiel_In.name)"

Im new to deluge and working on it 

any help would be apprichiated.

Mike