Script - Replace Field Contents with multiple criteria
Hello, I am running FileMaker Pro v12 on Windows XP and have the following script problem. Could someone please advise on how I can fix my Replace Field Contents to do the following:
I need the DbUserEdits::LetterSent field to change from value: "No" to value: "Yes" whereby:
DbUserEdits::LetterSent = "No" and DbUserEdits::DeploymentStatus = "Pending" or "Deployed" and Personnel::Service = "Army"
Please refer to my attached screen-shot.