Page 1 of 1

Records Window Column

Posted: 26 Aug 2011 13:01
by Carol
I have managed to add a Relationship to Root Column in the Records Window using the following: expression:

=Relationship(FileRoot(),,TEXT,1)

However, this also shows the relationship to the spouse eg 'Husband's Cousin'. Is there a way of not showing spouse's relatives in this column? I am using Version 4.1.3.

Thank you

ID:5413

Records Window Column

Posted: 26 Aug 2011 13:55
by Jane
Try


=TextIf(RelationCode(FileRoot(),%INDI%,SPOUSE_START,1) = 0,Relationship(FileRoot(),%INDI%,TEXT,1) , ' ')

Records Window Column

Posted: 26 Aug 2011 17:39
by Carol
Thank you Jane, I would never have been able to work that out. [smile]