How do I quickly populate a new empty field in my FMP dbase?

[Rocketman1]

My FMPro 6 dbase has 1,237 records. The field exists in each record. I want to add a new field, titled , and then automate the population of the new field with text based on the code in the existing field.

Example:

The field is populated with the codes EE, NA, CO, and AD. I want the new field , which is empty, to display "Engineering" for all records with the code EE or NA in the field

....and to display "Chemistry" for all records with the code CO, AD in the field.

Would a Loop script, or making the new field a calculation field, or would something else be the most appropriate/efficient, and what might it look like?

I'm sooooo stuck. Hope someone can help.

Don (novice)

[Raybaudi]

Hi

make the new field a calculation field (result text) and calc:

Case(

Area Tag = "EE" or Area Tag = "NA"; "Engineering";

Area Tag = "CO" or Area Tag = "AD"; "Chemistry";

""

)

[Rocketman1]

Yes. That works!

Thank you, very much, Daniele

Rocket