1 Reply Latest reply on Feb 17, 2012 1:12 PM by philmodjunk

    Omit records when no related records

    ShariFoucher

      Title

      Omit records when no related records

      Post

       I have two tables - dog registration and dog license, linked by dog id.  There are records in the dog registration table that do not have related dog license info.

      I need to print letters to send to owners to remind them to reregister.  I am doing a find on layout entry script that looks for deactivate = No in the dog registration table.  I also need to eliminate records from printing when there is no related dog license info.  I've tried several things, but can't seem to get the mechanics to work.

        • 1. Re: Omit records when no related records
          philmodjunk

          From the dog registration layout, you can use this method manually or in a script:

          Enter find mode

          put "no" in the deactivate field.

          Enter an * field from dog license that is never empty.

          Perform your find.

          This will find all dog registration records with "no" in the deactivate field that also has a related dog license record