Download: DataEase If Statement.jpg
First may I say thanks you for the explanation , and help with this situation.
Over the last few days I have tried different ways of doing the calculations without any success, I went back and have tried your suggestion
But without any joy still will not allow me to use :
if (rStockEntryForm_ON = lookup Proforma SellingCost, lookup rOHeader_On CompanyDoscount+lookup rOHeader_ON ExtraDiscount,blank)
Trying another approach I have attached a picture of the table involved with the Formulas I have placed in the Derivation box, as you will see they are all working accept the SellingCost field I wonder if you would be kind enough to have a look to see what you think I may be doing wrong .
Now what I am trying to say is. If ( the status is = proforma, lookup the rMaterial table sellingcost and discount that cost by the amount in the DiscountCalc filed if status is = anything else just use the selling cost in the rTable Materials.
if (Status= "Proforma" SellingCost = lookup rMaterials SellingCost - DiscountCalc , lookup "rMaterialsMC" "SellingCost" )
With regards to your note about I only use these as I was told years ago that its good practise to do so, but if we dont need them I can remove them .
Hope the way I have explained it may help solve this issue
Thanks again for your help .