4 Replies Latest reply on Nov 9, 2010 4:55 PM by GerrySmith

    Can't make a "Use values from field" validation work???

    GerrySmith

      Title

      Can't make a "Use values from field" validation work???

      Post

      Using FMPro 11 in single user on a Mac with OSX 10.5.8

      I have an Equipment_table with "Eq ID" as the unique key which is related to the "Eq ID" non-unique ket in my Equipment_Issues_table. I want FMP 11 to validate "Eq ID" on input to the Equipment_Issues layout in a script that 1) makes sure the equipment is in the Equipment_table, and 2) checks the Equipment_Issues_Table to insure it is not already issued.

      I set up the validation per the FMPro 11 Users Guide but can't get it to work. When I enter a non-existent "Eq ID" to test the validation, my custom message doesn't show. I am expecting it to work at data entry in the Enter Find Mode [Pause] script step before the Perform Find script step (on the other table). I've tried it with error capture on and off - no difference.

      Any Help?

      Validation_windows.gif