Need help with calculation / relationship / value list...not even sure what to call it!
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?