Graham J 0 Report post Posted April 15, 2008 How can I set a filter to find for example all William Bloggs who had a spouse called Mary? You cando it for sons and daughters mothers and fathers but not apparently spouses. Regards Graham Share this post Link to post Share on other sites
Michael Hannah 0 Report post Posted April 15, 2008 Your are probably trying to filter a List of Persons report or the Project Explorer. A marriage is an event, so a List of Events will probably be easier. Try a filter like: Principal1 Given Last contains William Bloggs AND Principal2 Given contains Mary END This works if all your males were entered as Principal1 and all females Principal2. If you were not careful about that data entry, then try a double set of conditions with parentheses like: ( Principal1 Given Last contains William Bloggs AND Principal2 Given contains Mary ) OR ( Principal2 Given Last contains William Bloggs AND Principal1 Given contains Mary ) END If you want to do some work on these people, then you could set a Flag on the Secondary Output and use the Flag to set the Project Explorer or create a Focus Group. Hope this gives you ideas, Share this post Link to post Share on other sites
Graham J 0 Report post Posted April 15, 2008 Thanks. That works fine. Regards Graham Share this post Link to post Share on other sites
Michael Hannah 0 Report post Posted April 15, 2008 Happy to help, glad that does the trick. Share this post Link to post Share on other sites