Complex Auto-enter calculation

[cr-dev]

Good day!

I am in the process of setting two fields to auto enter a total (number) for two conditions: A particular drop-down selection is made and based upon a location field.

example: I have a field named "Charges" and it has drop-down values of 95805, 95810, 95811. If I select "95810" I want it to populate two fields "Global Fee" with one specific charge and "Partner Fee" with another specific charge and in addition must evaluate a field called "location" to determine charges specific to that location. So I could have the follow senario in my table. (ignore the periods, they are only there to space out the data)

Charges | Location | Global Fee | Partner Fee

=================================================

95805.....El Paso.......1000.00........750.00

95805......Houston......1200.00........900.00

95810......Austin.......700.00.........500.00

95810......Dallas.......400.00.........150.00

etc...etc...

I was curious if there had to be a calculation value set on the "Global Fee" and "Partner Fee" fields, but not sure what would be the best practice here. Any help would be greatly appreciate! Thanks in advance.

Chris

[cr-dev]

Anyone? :violin:

[mr_vodka]

Various fees for regions should be stored in a fees table with each region having its own record. Then you could refer to this table when trying to calculated your costs.

Here is a recent thread with a similar situation.

Pricing Schedule