record sale with several sales persons

[learning]

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?

 

[Marc]

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