* Relationships

Homeless Posts from the old forum system
Locked
avatar
jeremyhills
Diamond
Posts: 96
Joined: 28 Dec 2003 17:05
Family Historian: V6

Relationships

Post by jeremyhills » 10 Feb 2011 12:11

When you sort on 'Relationship to Root' it sorts alphabetically i.e. 1st cousin comes top of the list. Is there any way to sort according to the closeness of the relationship?? This would show Father first, then grandfathers etc.

ID:4984

User avatar
tatewise
Megastar
Posts: 27088
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Relationships

Post by tatewise » 10 Feb 2011 13:28

Yes, you can use the Ahnentafel Number.

See the Help on Functions and look it up on Wikipedia.

In the Individual Records Window use Lists > Configure Record Window Columns and add a Column with the following Expression:

=Number(0-AhnentafelNumber(FileRoot(),%INDI%,1))

Then hold the Alt key to reverse sort on this column.

You could simply use =AhnentafelNumber(FileRoot(),%INDI%,1) but sorting then lists all unrelated individuals first.

User avatar
Jane
Site Admin
Posts: 8442
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Relationships

Post by Jane » 10 Feb 2011 13:57

The only problem with Ahnentafel is it only works for Ancestors, so you might want to look at generating something using the RelationCode() function, once you have decided what order you want cousins etc in when looking at the list.

Locked