Line items file

[rservis]

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