AnsweredAssumed Answered

Newbie: Replace text answer with number in second field?

Question asked by idwhite on Apr 12, 2010
Latest reply on Apr 12, 2010 by 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!

 

 

 

Outcomes