Hello, I am designing a database in which customers can place orders, and each order has the potential of generating a discount percentage. The discount percentages reset every year. A customer's first order is 0% off, their second, third, fourth and fifth are 5% off, thereafter 10% off until the end of the year is reached, then we start over again on 1/1 with 0% for the first order of the year. I'd like this percentage to be stored as a value in a field for each order. I could provide a drop down, and have someone manually choose the percentage based on the above, but I would much prefer to automate this. Thanks in advance for your help!