AnsweredAssumed Answered

Table Structure Setup for Commissions

Question asked by JamesPeragine on Dec 6, 2014

Title

Table Structure Setup for Commissions

Post

I need to setup commission tracking for my database and I'd really like to get some guidance so that I don't screw it up.  

I have a Deals table and a salesperson table that are related.  Is it best to set up a payments table and relate it to the deal table?  Or should I also make a commissions table and make a join table CommissionPayments?

Outcomes