Hello All,

I have two tables. The first table is my sold jobs and has the Profit Margin.

The second table has my commission rates.  In this table there are two records.  The active commission scale and an inactive commission scale that is not being used any longer, but associates with some older Sales.  Each record has the commission rates and the breakpoints . see screenshot: for clarification.

The sliding scale works like this:

If the profit margin is between 0-20.99%  it pays a 2% commission, a profit margin between 21-28.99% pays 4% commission rate.   etc. etc.......

Need a little help figuring the best way of implementing the sliding commission scale that automatically selects the appropriate commission rate based on the profit margin of a Sale and adds the appropriate commission rate to the sold jobs table.