I'm trying to create this calculation with little results.

What I need to do is have a field calculation ('CALC PHASE') that bases different results based on the contents/value from another field (titled 'PHASE').

So if the field PHASE had the following value/text:

1 it would return "something1" in field "CALC PHASE"

2 it would return "something2" in field "CALC PHASE"

3 it would return "something3" in field "CALC PHASE"

4 if would return "something4" in field "CALC PHASE"

Hope that makes sense...thanks in advance!

Here is a very simple way of doing this:

You will need to hard code the triggers, And, I would make a value list for them in the Phase Field.

Lee

CalcPhase.fp7.zip

wow thanks for the quick reply!!!