* Show Relationship to 2 People in ISR Output

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
avatar
BobWard
Superstar
Posts: 420
Joined: 18 Nov 2012 01:50
Family Historian: V6.2
Location: Mesa, Arizona, USA

Show Relationship to 2 People in ISR Output

Post by BobWard »

I am generating an Individual Summary Report (ISR) for a combined family tree, which will include both my and my wife's sides of the family.

Currently, I am the Root person in the tree and I use the expression "=Relationship(FileRoot(),%INDI%)" in the Report Options>Contents>Main Sections Items box to label my relationship to each person in the ISR output.

Since this ISR also includes my wife's family, I would like to find a way to include my wife's relationship to each individual in the ISR as well, which would be listed right below my relationship to those individuals.

I cannot find a way to create 2 Root individuals that could be listed with relationships to each person in the ISR.

Is this task possible, or will I have to generate a separate ISR with my wife as the Root person?
avatar
Gowermick
Megastar
Posts: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Show Relationship to 2 People in ISR Output

Post by Gowermick »

Bob,
I can’t answer your specific question, but I guess what FH will report will not be what you are looking for!

If, for example, an individual is shown as your 2nd cousin, FH will most likely report that your wife’s relationship to this individual would be along the lines of Husband’s 2nd cousin , whether this individual is directly related to your wife or not.

I have a 1st cousin, whose husband is distantly related to our 2 or 3 ’GreatGrandfather, but his relationship to me is always shown as Husband of 1st Cousin!
Mike Loney

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
tatewise
Megastar
Posts: 28333
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Show Relationship to 2 People in ISR Output

Post by tatewise »

Bob, you can show the relationship to anybody without changing the File Root.
Just replace the function parameter with whoever you want to be the root person.
e.g.
=Relationship( Record( 321, "I" ) ) for the person with Record Id [321]
=Relationship( %CUR_FILE_ROOT.~SPOU[1]>% ) for the 1st Spouse of the File Root.
i.e.
When in the ISR Options to Add Item after inserting =Relationship() function, put the cursor inside the parentheses and click <<Insert Data Reference where you can choose various relatives of the File Root.

Mike, =Relationship() shows the closest relationship between the current person and the 1st parameter in the function.
But it can show more distant relationships by setting the 2nd parameter to 2 or more.
e.g.
=Relationship( FileRoot(), 2 )
There are ways to exclude relationships via Spouses by using =RelationCode(FileRoot(),%INDI%,SPOUSE_START,1) = 0 as explained in Display Multiple Relationships in Pedigree Diagrams (16414).

FH is not reporting the relationship you mention via your shared 2 or 3 ’GreatGrandfather' because then the description would be much more involved and is much more distant. The closest relationship is as Husband of your Cousin. But if you exclude relationships via Spouses then you should usually get what you want.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
avatar
BobWard
Superstar
Posts: 420
Joined: 18 Nov 2012 01:50
Family Historian: V6.2
Location: Mesa, Arizona, USA

Re: Show Relationship to 2 People in ISR Output

Post by BobWard »

Mike,

Using your suggestion, I inserted =Relationship( %CUR_FILE_ROOT.~SPOU[1]>% ) for the 1st Spouse of the File Root. And, put my wife's maiden name in the Label box.

The resulting ISR produced the following output (see attachment) for one of our shared relatives, Charlemagne. As you can see it is listing her relationship to Charlemagne as a function of my relationship, not her direct relationship to him.

I should note that we both have multiple relationship paths to Charlemagne, so FH does have some choices to make here as to which of those relationships it lists for each of us. This kind of gets into that same issue we had a few weeks ago when you revised the All Pool Relatives Except Partner Ancestors to better account for the ways in which some shared ancestors of my wife and I were being listed in the All Relatives diagram.

With about 2,200 people in the ISR database, this may be a difficult goal to achieve without having to make special modifications for each relative.
Attachments
Husband & Wife Relationships to Relatives.JPG
Husband & Wife Relationships to Relatives.JPG (244.24 KiB) Viewed 3944 times
User avatar
tatewise
Megastar
Posts: 28333
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Show Relationship to 2 People in ISR Output

Post by tatewise »

A similar solution as for the All Relatives Diagram can be applied to ISR.
The Expression will be more complex as you will have to nest the TextIf(...) functions.
e.g.

Code: Select all

=TextIf( RelationCode( %CUR_FILE_ROOT.~SPOU>%, %INDI%, SPOUSE_START, 1) = 0, Relationship( %CUR_FILE_ROOT.~SPOU>%, %INDI%, TEXT, 1), TextIf( RelationCode( %CUR_FILE_ROOT.~SPOU>%, %INDI%, SPOUSE_START, 2) = 0, Relationship( %CUR_FILE_ROOT.~SPOU>%, %INDI%, TEXT, 2), Relationship( %CUR_FILE_ROOT.~SPOU>%, %INDI%, TEXT, 1)))
However, this may run into problems if it gets too long!
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
avatar
BobWard
Superstar
Posts: 420
Joined: 18 Nov 2012 01:50
Family Historian: V6.2
Location: Mesa, Arizona, USA

Re: Show Relationship to 2 People in ISR Output

Post by BobWard »

Thanks for the suggestion Mike. However, that complex of an expression is going to be beyond my capabilities to deal with.

With over 2,000 relatives in the database, I will undoubtedly run into issues. I think my safest bet will be to just print out 2 separate ISRs, one for my side of the family and one for my wife's side. The 2 separate ISRs would be generated from two separate FH projects created from your recent revision for the All Pool Relatives Except Partner Ancestors plug-in. That seemed to work pretty good for getting correct relationships in the All Relatives diagram, so I would expect similar results for the ISRs. Of course, I will continue to keep my combined family FH project as my master project database.

Thanks for your help.
Bob
Post Reply