AnsweredAssumed Answered

calculation problem for text

Question asked by CountryBoy1 on Mar 14, 2009
Latest reply on Mar 16, 2009 by CountryBoy1


calculation problem for text


   Been away from Filemaker Pro 9 for several weeks.  Tried to set up

a field that looks at the City Name in another field and uses a

calculation (Case statement) to come up with a Zip Code.  Can only

get it to work for the first City Name.  Zip Code is defined as text.

    When should a field type be defined as a "calculation" and when should

it not be ?  Tried it both ways, having Zip Code as a "text" field that

uses a calculation and having it as a type "calculation" that uses a calculation.

Have the same problem both ways.

   Thanks for your help.