Can't make a "Use values from field" validation work???
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.