Over time I have 'acquired' people who are not blood relatives - parents and siblings of wives or husbands of uncles, aunts, etc.
I have been trying to write a query to list these people, but don't know where the Relationship expression is (assuming there is one).
I am aware that I can add relationships to the Records Window, but this shows everybody.
Help would be appreciated.
Cheers
Roger
ID:6918
* Relationship to Root
-
Jane
- Site Admin
- Posts: 8441
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Relationship to Root
The easiest way is to run the standard 'Relations, Excluding Relations by Marriage' then select 'Run and Invert result set' from the query menu button to get everyone who is not a blood relation.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
-
rodit
- Famous
- Posts: 228
- Joined: 02 Feb 2008 02:39
- Family Historian: V7
- Location: Wollongong, New South Wales, Australia
Relationship to Root
Thanks, Jane
I have obviously not seen that query before.
Roger
I have obviously not seen that query before.
Roger