AnsweredAssumed Answered

Using a script to populate two fields

Question asked by EmmettOliver on May 19, 2011
Latest reply on May 25, 2011 by philmodjunk

Title

Using a script to populate two fields

Post

Hi,

I have two tables (screen shot below).  I have a drop down list for the counties that would be user selected.  I want to use the selection from the user in the "County" field of the "Table" table (I know its crazy but I inherited the db) to set the fields "County Code" and "Region".  The idea is to make data entry easier and more efficient.  So, I tried using if then statements but that didn't work.  Should I be using the "Set Field" script and use a GTRR calculation.  Also, I am new to FM and scripts.  Any help would be much appreciated.

FM_Tables.GIF

Outcomes