AnsweredAssumed Answered

get price data from an input

Question asked by bparry on Dec 18, 2015
Latest reply on Dec 22, 2015 by Mike_Mitchell

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.

 

Ben

Outcomes