* Generation Number

Homeless Posts from the old forum system
Locked
avatar
Carol
Gold
Posts: 16
Joined: 24 Sep 2003 09:34
Family Historian: V6.2
Location: England

Generation Number

Post by Carol » 14 Sep 2009 17:57

Is it possible to have a column in the Records Window that shows the Generation Number to the File Root?  If it is could some kind person please give me the Data Reference/Expression or an idiots guide of how to do it?

I have tried Configure Columns...Load from Query...All Individuals (custom), but the Generation Column shows zero for everyone (it shows correctly in the Query Window so I am obviously doing something wrong).

Thank you

Carol

ID:3999

avatar
Bilko
Diamond
Posts: 69
Joined: 04 May 2009 20:03
Family Historian: None

Generation Number

Post by Bilko » 14 Sep 2009 18:54

Hi Carol,

Yes you can show the generation number respective to the File Root.

The easiest way of doing so is :

a. Right click on the column header and select Configure Columns ..

b. Select one of the possible column headers from the left side and copy it to the right side using the button in the centre,

c. on the right side select the new column that you added in step b. and click the edit button that is then highlighted,

d. in the 'Edit Column details' box, change the 'Heading' to Gen (your choice),

e. copy and paste this code into the expression box -> =Relationcode(FileRoot(),,GENERATION,1) .


This will give a Negative number for the number of generations for Ancestors and a positive number for Descendants. To reverse this use this code -> =Relationcode(,FileRoot(),GENERATION,1) .

Hope this helps.

Bilko


[cool]

avatar
Bilko
Diamond
Posts: 69
Joined: 04 May 2009 20:03
Family Historian: None

Generation Number

Post by Bilko » 14 Sep 2009 18:57

Apologies,

I forgot to mention in my previous post that persons who are not related to the File Root will not have a number in the Gen column and those who are related and of the same generation will have a zero.

Bilko

[wink]

avatar
Carol
Gold
Posts: 16
Joined: 24 Sep 2003 09:34
Family Historian: V6.2
Location: England

Generation Number

Post by Carol » 15 Sep 2009 18:23

Hi Bilko

That works perfectly, thank you for such clear instructions, I just can't get my head around these data references.

Carol

Locked