record sale with several sales persons

record sale with several sales persons

Post by learnin » Fri, 24 Sep 2004 21:31:20


What would the proper way be to enter a sale, then be able to enter 1 or
more sales persons, their "costs" to the sale, and their commission on the
sale?
 
 
 

record sale with several sales persons

Post by Marc » Sat, 25 Sep 2004 09:16:15

Hi

tblSales
SaleId (or whatever the PK is)

tblEmp
EmpId (or whatever the PK is for the file the sales people are on)
CommRate | if standard /default across sales.
CostRate |

tblSaleEmp
SaleId
EmpId
CommRate | if overriding / or there is no standards
CostRate |

So for each sale you have as many records on tblSaleEmp as required for the
number of sales people involved in the sale.

There are many more variations depending on the complexity of your
commission structure.

HTH
Marc