I want to create a new custom query, based on the Kinsfolk Census To Do query, but that only lists ancestors and spouses of the chosen root.
Can someone point me in the right direction please.
ID:6722
* New Query Based on Kinsfolk Census To Do Table
- tatewise
- Megastar
- Posts: 27088
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
New Query Based on Kinsfolk Census To Do Table
You need to add some filters to the Rows tab using the Relations tab at the bottom.
e.g.
Condition: Exclude unless Relationship: Ancestor select This individual and Parameter Label Person.
There are options to Inc. original individual and Inc. spouses of relatives.
If you only want the Spouse of root Person instead of every relative then
Condition: Add if relationship: Spouse select This individual and Parameter Label Person (same as above).
e.g.
Condition: Exclude unless Relationship: Ancestor select This individual and Parameter Label Person.
There are options to Inc. original individual and Inc. spouses of relatives.
If you only want the Spouse of root Person instead of every relative then
Condition: Add if relationship: Spouse select This individual and Parameter Label Person (same as above).
- davidm_uk
- Megastar
- Posts: 740
- Joined: 20 Mar 2004 12:33
- Family Historian: V7
- Location: St Albans, Hertfordshire, UK
New Query Based on Kinsfolk Census To Do Table
Thanks Mike, I've got it close enough to what I want as a result of your help.