### Title

Calculating Prices With a Sliding Fee Scale

### Post

Once again thanks for your previous assistance, now that FM is calculating my total size, is there a way to do fee calculations with a sliding scale? Basically the bigger unit you buy, the cheaper the per inch the fee is

For Example if it measure 1-15 total inches the fee will be $15.20/inch

if the total inches are 15.25-30 the fee will be $14.50/inch and so on, but to make it more complex there are 3 exact measurements that get discounted to a total dollar amount instead of a per inch charge (those are 35, 70, and 150)?

I don't know if maybe I could use the > < and = signs to simplify this? And if it's not too much to ask could this be set up so the salesman can override the price calculation (in case of mass quantity ordering, make goods, etc)?

Thank you in advance for any advice or experiences you can lend

You can set up a related table with one field as the Max inches and the other field as the rate to charge.

Your original table can then use an auto-enter field option and the relationship to copy over the rate. Since this rate would be copied into a simple number field, the user can be allowed to modify the rate when necessary.

Take a look at the Looked up Value auto-enter option and note the options that you can select if there is "no exact match".

Note that with this related table approach, updating your pricing tiers is a data entry task not a database design change task.