Hi Naomi,

I got it. Your code will not work because the crsCNT.PartNum is a parent part of the parts in crsMaster.

SELECT a.PartNum, ..., a.QtyPer * c.CurQty as QtyReq, ;
b.OnHand - (a.QtyPer * c.CurQty) as NetQty ;
FROM crsCNT c, crsParts a LEFT OUTER JOIN crsMaster b ;
ON a.PartNum = b.PartNum ;
INTO CURSOR crsTemp

Thanks again,
Sam