Page 1 of 1
Named List query
Posted: 09 Mar 2020 13:42
by Jessie 888
Apologies if this is a daft question but I can’t find the answer anywhere else. I’m working on a Named List of 168 individuals who are in my tree and whose DNA tests confirm our ‘paper relationship’. I’ve worked out how to add a column showing our relationship but what I’m trying to do now is to add one more column where I can list our common ancestral couple … like Henry Brenton and Fanny Old. Is that possible on FH or should I save the list (somehow?) to Excel where I can manually work on it there? Sorry but I’m stumped and not IT-savvy enough!

- named list query.png (63.21 KiB) Viewed 4199 times
Re: Named List query
Posted: 09 Mar 2020 15:40
by tatewise
No, I cannot think of a way to add such info into a column.
But you can add those Family records to the Named List interleaved with the Individual records.
So you would have each Individual record followed by the common ancestral Family couple record.
You can use the up/down black arrows top right to get them into the desired order.
Then use Lists > Keep Current List Order to preserve the interleaved order.
If you update the Relationship to Root column Expression to:
=TextIf( RecordType() = "I", Relationship(FileRoot(),%INDI%,,), Relationship(FileRoot(),%FAM.HUSB>%,,) )
then it will show the relationship for each Individual and each Husband of the couples.
Re: Named List query
Posted: 09 Mar 2020 16:55
by Jessie 888
Many thanks, Mike. I'll have a closer look at that tomorrow when my brain is in gear!
Re: Named List query
Posted: 09 Mar 2020 18:23
by Jane
You might find this useful
https://www.taubman.org.uk/family/wp/20 ... historian/
I do it this way as I don't always know how they all join up.
Re: Named List query
Posted: 10 Mar 2020 17:58
by Jessie 888
Thank you, Jane!
Re: Named List query
Posted: 13 Mar 2020 09:45
by Jessie 888
Just a quick update. I found a solution that comes under the 'simple but works well for me' banner! I've just created separate named lists for my main ancestral couples. So now, whenever I find the connection with my DNA match, I just add their Individual Record to my main DNA list and also to the specific shared ancestors named list. Very happy (as always) with Family Historian!
