• We have a field called Products which is a link to our “Product” table



• We have a field called Cost which is a lookup field. (looks up the cost from the Product table)



• In our “ORDER” table, we have a field called Total Cost
  
  

In that Total Cost field we would like to multiply the Cost by the Qty (quantity) but if there is a value in the Misc Cost field then we would like to multiply that field by the Qty to calculate the Total Cost

Here’s the kicker…

Basically, we want to use the Misc Cost to override the Cost x Qty total, if there if something is entered in that field.

Usually a product is full price for us. Sometimes we get a massive discount on a certain quantity or we get some of a product for free. I still want to link to the existing product from our database, but I want to have this Override field and have my “Total Cost” field use the Misc Cost field, if it’s exists.

Sorry if I didn’t explain this very well. Any help here would be great!!