I have created an order form we fill in while our customer is on the phone with us. We enter the Product ID and auto enter the description. We offer quantity discounts, for example; 1- 12, 13 - 24, 25 - 50, 51 - 100. How can I get the quantity discount price to be automatically entered based on the quantity we enter in the quantity field?

Thank you in advance for your help.

Gary

Good suggestion. To avoid hard-coding the prices into the calculation, create global fields for each price and refer to the global fields in the calculation.

Even better (because globla fields become tricky in multi-user environments) is to create a "preferences" file to hold the prices.

Make the price field a calc (or at least an auto-enter), and use the "Case" statement in the calculation.

e.g.:

Case(Quantity > 100, 5.25,

Quantity > 50, 5.75,

Quantity > 25, 6.50)

etc.

Too true, Vaughan.

Additionally, since those unit prices will occasionally change, I suggest making the discount price field a number field with an auto-enter calculation, rather than a calc field. That way, once the price is figured (based on the quantity ordered), it won't change when you change your unit prices.