Scipt or Calculation help
Can anyone tell me how to write and apply a script, or calculation for the following:
I have a 'Country' field with pull down menu so that I can choose one from 12 countries. I have another field which is for a 'Country Prefix'.
So - if someone selects 'United Kingdom' from the pull down list in the 'Country' field, I would like the 'Country Prefix' field to be propogated with 'UK' (same sort of thing with all the other countries)
I have managed to do it with Access a few years ago, but can't figure out how to do it with FMPA 11
Any help would be appriciated