Relationship to Root

Stevebye · Post by **Stevebye** » 22 Jul 2013 12:18

=Relationship(FileRoot(),%INDI%,TEXT,1) works fine until the sex of the person is unknown.

Have a stillborn child born 1929 that no one knows if boy or girl. I cleared the 'Sex:' box and when building a Diagram or Report a male relationship is shown. I expect =Relationship(FileRoot(),%INDI%,TEXT,1) is defaulting to Male as that is the first option in the 'Sex:' menu.

Is there anyway of returning both the Male / Female relationship or no output when the sex is unknown ?

ID:7016

PeterR · Post by **PeterR** » 22 Jul 2013 12:47

I suppose 'child', 'grandchild', 'great grandchild', etc., would work for direct descendants of the root individual, but I'm not aware of a gender-neutral term for niece/nephew.

Post by **tatewise** » 22 Jul 2013 13:08

The following would produce no output if the Sex is undefined.

=TextIf( IsEmpty(%INDI.SEX%), ,Relationship(FileRoot(),%INDI%,TEXT,1) )

Stevebye · Post by **Stevebye** » 22 Jul 2013 13:15

Thanks Mike. Spot on as usual [smile]

Family Historian User Group