AnsweredAssumed Answered

calculation lookup question

Question asked by on Sep 6, 2013
Latest reply on Sep 7, 2013 by philmodjunk


calculation lookup question


     On the order layout I want to pick a material which is a drop down match of the list of materials on the materials layout, then I want to type a width and a thickness. 

     I want the system to look at the materials a return an “order::price” based on a material match which is based on width less than or equal to “Materials::Width” and thickness less than or equal to “Materials::Thickness” but return closest value to both width and thickness and not all values less than or equal to.