I'm working in FM-Pro 12 Starter Solution: INVOICES.
I need to assign a field that will allocate a discount based on a customer's repeated purchases (loyalty points). The Discount happens on the 5th, 10th and 15th purchase -- 10%, 20% and 30% respectively.
Old customers (archived on file cards and about to enter the database are at various levels 1-15-- I have created a field indicating the respective level in the Customer table). New customers will start at purchase #1. After the 15th purchase, the cycle begins again.
How might I formulate such a discount set-up?