Newbie: Replace text answer with number in second field?
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.
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!