1 Reply Latest reply on Jul 6, 2011 10:55 AM by philmodjunk

    Record search question



      Record search question


      I've been using Filemaker Pro 10 for a couple of years so am reasonanably competent. However, I can't quite work out the solution to this simple problem.

      My records contain an address consisting of six fields. Address line 1 to 3, town, county and postcode. I've noticed that some users have entered records and not entered anything in line 2 but in line 3. How would I do a find to locate the records where I would need to find empty line 2 records but which also have populated line 3's? I can do one or the other easily.