AnsweredAssumed Answered

Help with complex find...

Question asked by 1957GoldTop on Mar 7, 2013
Latest reply on Mar 8, 2013 by philmodjunk

Title

Help with complex find...

Post

      

     I've imported some data into FileMaker and I'd like to perform a complex search on the data.  My data would be something like:

Company, Job Title
Best Company, Admin
Best Company, Supervisor
Beans Ltd, Admin
Beans Ltd, Admin
Gas Guzzlers, Admin
Gas Guzzlers, Supervisor
Prime Time, Admin
Prime Time, Admin

I would like to perform a search such as "show me all the companies that don't have a Supervisor".  The resulting list should be:

Beans Ltd, Admin
Beans Ltd, Admin
Prime Time, Admin
Prime Time, Admin

     Can FileMaker do this and if so how?

Thanks!

Outcomes