10 Replies Latest reply on Oct 8, 2014 11:40 AM by philmodjunk

    help with scripts in FM 11

    jessekmiec

      Title

      help with scripts in FM 11

      Post

       I have a database (FM 11) that i would like to have zip codes in one column associated with a "region" in another. I would like this to be automated where as i enter the zip code in column one and column 2 would set itself automatically to the predefined region. Simply put if i enter a zip code from the Los Angeles area in the zip column i would like the geography column to automatically have "L.A. Area" entered into it. Subsequently if i enter a zip from brooklyn into the zip column i would like the geo column to have brooklyn automatically entered.

       

       I have limited experience with scripting and think i should use the "IF" script but i do not know how to set the automatic setting of the second column. Can anyone here help me out with this?

      All i can figure out so far is

      IF [Get(ZIP) ="11233"]

      i need if the IF is yes for field (geography) to return as Brooklyn.

       

      Anyone? Please? I love you :)