Adjust value of field based on the value of another field
In my field UnitPrice I wish to adjust the value based on the volume in the field PlatesOrdered. The values are:
Values of PlatesOrdered Value of UnitPrice
10 - 19 171.99
20 - 49 167.96
50 - 99 162.87
100 - 249 159.58
250 - 499 154.67
500 - 999 151.40
1000 and greater 148.27
