Using a script to populate two fields
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.