3 Replies Latest reply on Jan 17, 2013 1:00 PM by martinc

    Negative Testing...find what's missing


      We use: fmsa 11 on WinServer 2008 with users on Win XP using fmp11, I use fmpa11 mostly on windows


      Part of our system holds a training table to log training events. I'm pretty solid on finding what we Do have. I having a challenge on finding what we Dont have..


      We have a few tables that relate to this



      Training Events


      We create a training event and link a classs to it as well as the employees that attended. Pretty cool. I can see related events on a particular employees record.

      What I really want to see is what's MISSING.


      Example: There is a class for xyz and I want all employess of job title 123 to take this class once per year. I'd like to know at a glance who needs to still take xyz class. How do I search for non-existent related records?






        • 1. Re: Negative Testing...find what's missing

          Perform a find for all employees with a job title of 123 then do a constrain found set to omit those with class xyz. In a script it would look something like this of course setting the appropriate action and criteria in each step.


          Perform Find [Restore]

          Constrain Found Set [Restore]



          • 2. Re: Negative Testing...find what's missing
            Stephen Huston

            You can also program the search Nick mentioned as a 2-request search rather than performing a second search to constrain the results of the first search


            Find: employees who may qualify


            Omit: those who already have the XYZ record in existence.


            [ Keep in mind that when searching via a relationship, you need to be testing for the existance of something specific, not for a blank related record. Searching for a blank via a relationship usually returns all records in the parent table. Sometimes you have to do a omit on "≥ 0" (omit greater or equal to zero) to avoid this relationship surprize. ]

            • 3. Re: Negative Testing...find what's missing



              Thank you!  The constraining with an Omit seems to work very well.  This will be easy to roll into scripts.  Next time I'll try to ask a harder question..