AnsweredAssumed Answered

Help with script please

Question asked by ChrisSmythe on Jan 11, 2013
Latest reply on Jan 13, 2013 by Sorbsbuster

Title

Help with script please

Post

     Hello, I am using FileMaker Pro 12 on Windows XP.  I am having some difficulty trying to make my script work as shown in the screen-shot below.

     I am trying to perform a find such that the following happens:

     1.  It goes to layout: Find Emergency Contacts which come from the Emergency Contacts table;

     2.  Enters Find Mode;

     3.  Set Field - Personnel::Service that equals "Army";

     4.  Set Field - EmergencyContacts::RelatedToEmployeeID for all RelatedToEmployeeIDs that are less than 8510000

     5.  Perform the Find.

     6.  The field type of RelatedToEmployeeID is: Text.  That is because some of the RelatedToEmployeeIDs have alpha-numeric characters in them.

     7.  I am unable to get Step 4 (shown above) to work properly.  Step 3 (shown above) works fine.

     I do not know how to script FileMaker to find RelatedToEmployeeIDs that have a value less than 8510000.

     Could some one please be kind enough to help me get my script to work properly?

     Any assistance would be greatly appreciated.

     Kind regards,

     Chris smiley

EC.png

Outcomes