This is an Access 2003 program. There are 140 salespersons in 22 offices with all different compensation agreements. Some have assistants, some don't. Some of these assis. receive compensation some don't. All commissions are calculated as a percentage of the profits from each deal. Also there must be a table of money owed by each to automatically come out of their commission each time the owe money...and that debit then being removed because it been paid. All I need is the table design an a written explanation of how you came up with it and your thinking of the database flow as I create a commission
## Deliverables
All I need is the table design an a written explanation of how you came up with it and your thinking of the database flow as I create a commission
## Platform
XP