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.