2 Replies Latest reply on Mar 23, 2009 2:55 PM by CountryBoy1

    Validation Calculation Problem



      Validation Calculation Problem


      Trying to use a validation calculation to check the range of

      a numeric value that is entered into a field.  The validation
      depends on two other fields in the same record. An incorrect value

      can be entered and the validation will not work until a different

      record is selected. Then the validation error message appears.

       Why won't the validation work while editing is performed on

      the given record ?

       I have even put the validation code inside an evaluate function(),

      telling it to trigger on the two other related fields, but still no
      improvement.  Thanks for your help.



        • 1. Re: Validation Calculation Problem

          CountryBoy1 asks "Why won't the validation work while editing is performed on the given record ?" Record validation won't take place until the record is "committed". This happens when you exit the record in some manner such as when you click or tab to the next record. Until then, Filemaker assumes that you are still entering or modifying data and won't check validation until you are "finished". Exiting the record is the signal (trigger) to filemaker to do that.


          If you are using FMP 10, you can set script triggers to check values when a field is exited, when it is modified or even when a specific key is pressed. I use script triggers with one of these events to check for errors before the record is commited. If you use v10, that's your best choice.

          • 2. Re: Validation Calculation Problem

            Dear PhilModJunk:

                     Thanks for your reply.  I sort of figured it was necessary to exit the record,
                   but was hoping for another answer.  I am using Filemaker Pro 9.   Doubt if
                   I will go to Version 10 anytime soon.


                      I have selected your reply as the answer to my question.


                   Sincerely, CountryBoy1