AnsweredAssumed Answered

Record search question

Question asked by Kobyashi on Jul 6, 2011
Latest reply on Jul 6, 2011 by philmodjunk

Title

Record search question

Post

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.

Outcomes