Problems using the Script Manager
I'm just about tearing what's left of my hair, out! I have spent 4 hours trying to write the simplest of scripts, but I just can't seem to get the syntax right.
I have a field 'UoM_OD' which is filled via a Value List to be either "Met" or Imp", and depending upon which it is, I need another field 'Tmm' to display either "mm" or "in" respectively.
I would have thought, from all my research that a script like this should work, but I've tried a multitude of variations without success...
If [DB_Prep::UoM_OD = "Yes"
DB_Prep::Tmm = "mm"
Else DB_Prep::Tmm = "in"
Can anyone tell me where I'm going wrong?