I have two tables. one is the data form, the other is a price table.
the price table has uid for each price set with an m1, m2, m3 etc for the field and each has a provided data value.
In the form they have a field called damage which they input a number which represents the damage %
that damage number I want to use to look up the price for the %. each m number in the price table is to represent the % value.
example if I used 50 in the damage field on the form I want it to look up m50 data from the table to get that price damage and output to
another field total cost.
I have tries many ways to figure this out on my own and hit a wall on how to do the calculation.
I tried to use my programming background to make total cost = MTABLE::"m"+damage" but its invalid to do that way.
Any help would be great thanks.