February 15, 200718 yr Hi, Hope you can point me in the right direction.... I want to display in my line items file the commission % based on the criteria of - Employee and Type. I have setup the types (Product 10%, Services 15%) on the employees table. At present it displays on the line items table the employees name and the type (Both via Calcs from the appointments table) - what i need to do (I think) is build up a case statement.... But how would that work if you add a new employee??? If i can get the % number in a field in the line items table, it should be easy to calc a employees commissions based on what they have sold? (Is this the best way to go about this?) Thanks in advance, Roy
Create an account or sign in to comment