result from 2 different fields w/value lists

[FM Bash!]

I have 3 fields: H, W, Total

H & W use value lists.

W uses 1,2,3,4,5 in the value list.

H uses 1, 1.5, 2, 2.5, 3, 3.5 (and so on)

What I am trying to get in the total field is a pre set dollar value based on the choices made in the H&W fields.

Sort of what I am trying to say or do. if ("W"=1 and "H"=2.5, "total"=(24.50)

Example: If a user chooses "1.5" in the H field, and "2" in the W field, the total field would display a pre set dollar amount.

I do understand this will be a good number script lines for all the combinations. [color:"red"]

[-Queue-]

How is the total derived from the W and H fields?

It might be easier to use a separate file with each record containing one H, W, and Total combination. Then create a relationship based on a concatenation of the H and W fields (H & "_" & W) in both files. For the total field in your main file either use the related field (in which case you would need to Total field in the main file), a calculation of the related field, or a lookup of the related field (if you want the data to stay constant even if/when the related Total changes).

[FM Bash!]

W & H were input as width & height. I did figure out this one.

I have posted a new one that I am stuck on.

Please take a look at it when you get a chance.

Thanks!