I am trying to perform a search with no luck.
I want to search for all parent documents that have a common search term in any of their respective child (response) documents.
To be more specific, I have a contact database, each contact has several child/response documents assciated with them (like notes or emails etc). I want to search for all contacts that have a common term in their response docs, ie find all contacts that have a note associated with them with the term"Project XYZ"
I do not want the search to return the response docs but the parent docs.