0 Replies Latest reply on Dec 6, 2014 11:58 AM by JamesPeragine

    Table Structure Setup for Commissions

    JamesPeragine

      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?