Jump to content
Graham J

Filtering people who share a spouses name

Recommended Posts

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×