4 Replies Latest reply on Apr 12, 2010 8:54 AM by idwhite

    Newbie: Replace text answer with number in second field?

    idwhite

      Title

      Newbie: Replace text answer with number in second field?

      Post

      Hello, I am new to FM11 using the trial...

       

      I have two fields.  I need the second field to automatically show a number based upon the text entered into field 1. 

       

      ie... 

      Field One: "A"    Field Two: automatically enters: "123"  or if...

      Field One:  "B"    Field Two: automatically enters: "456"

       

      FieldOne is currently TEXT with POP-UP MENU from LIST with my predetermined values.

      FieldTWO is currently CALCULATION... Is this correct? I tried doing a calculation such as If (fieldone = "A"; "123") but it only works if I do it the one time. If I try showing that plus other answers= other numbers, none of it works.  

       

      I would appreciate any help with this! Thanks so much!