1 Reply Latest reply on Oct 17, 2011 9:54 AM by philmodjunk

    Find blank records in popop menu fields

    MikeF

      Title

      Find blank records in popop menu fields

      Post

      When enter Find mode, and use "=" to find blank records, it does not work when the field is a popup menu.

      Says there are no matching records, but there certainly are.

      What am I doing wrong?

      Thanks.

        - Mike

        • 1. Re: Find blank records in popop menu fields
          philmodjunk

          Are you performing the find manually or with a script?

          Using a script, the format of the field should make no difference if you specify the "=" inside the perform find step's stored criteria or use set field to enter the operator after entering find mode.

          One detail that can also be a factor is if the field is defined in the table referred to in Layout Setup | Show Records From or is defined in a related table.