Applying a Quantity Discount
I have a database that currently looks up a price and then generates an invoice at the end of a week for a particular client. Now based on an individual client because every client has different qty. discount criteria and gets different discounts. But at the end of the week if they purchase X amount of merchandise they get X amount taken off. What would be the best way scripting or a calculation, and what kind would be best to use. Any help will greatly appreciated.