AnsweredAssumed Answered

Need help with calculation / relationship / value list...not even sure what to call it!

Question asked by vincel on Feb 19, 2013
Latest reply on Feb 22, 2013 by philmodjunk

Title

Need help with calculation / relationship / value list...not even sure what to call it!

Post

     I'm trying to figure out how to make this work (if it's even possible).   I have the following fields setup as value lists that are used for data entry

     Shirt type - examples are short sleeve, tank, long sleeve, etc

     Shirt Size - L, XL, S, etc

     Number of shirts - any numeric value

     State - All the US states

     Now after entry is done I need to take this data and reference a chart (currently offline) to get an inventory value per record.   I have a different chart for each state.

     So for instance 4 short sleeve shirts that are large in size and are in stock in Arizona have an inventory value from my chart of $4.00.   Any change to any of the fields changes the value of the inventory.  There is no mathmatical equation to calculate this, the chart must be referenced for the exact value I need.

     Is there a way to have FM do this search for me?

      

Outcomes