How would I perform a find for an empty relationship?

[James Gill]

This seems like an easy question but for some reason the solution is escaping me.  Say I have a parent and child table where the parent may not have a related child record.  How would I go about finding all instances of a parent record that does not have a child record?  I can easily find all instances of a parent that DOES have a child record by specifying "*" in the primary id field of the child record but specifying "=" returns no results.

I feel like I'm missing something easy here...

[eos]

I can easily find all instances of a parent that DOES have a child record by specifying "*" in the primary id field of the child record

And once you've done that, select Show Omitted Only.

[comment]

To find records that don’t match the request's criteria, omit the request before performing the find:
http://www.filemaker.com/help/14/fmp/en/html/find_sort.5.14.html#1028490
http://www.filemaker.com/help/14/fmp/en/html/scripts_ref1.35.85.html#1145916

 

 

[James Gill]

Ah that makes sense, perform the find on a pre-omitted found set.