* View Ahnentafel Ancestors List numerically

[Baysig8]

Hi.

Have managed to add the Ahnentafel numbers in the Individual Records (thanks to Bill, 13 Nov 2021, 5:47). All 14,459 of them, so far.
I need, however, to view and print the record of Ahnentafel numbered Ancestors numerically - from #1 through to the #14,459 ancestor.

Currently, I can only see the Ancestors list as it appears, alphabetically.
Yes, I do have the Ahnentafel-numbered Diagram, so that's great.....but a compact record/list is what I need as well.

Would you kindly let me know the steps required (as simply as possible, please!) to enable this?
Kind regards, Lorraine

[tatewise]

Welcome to the FHUG Lorraine.

You can view the Records Window in Ahnentafel order by clicking the Ahnentafel column header.
That trick works in many tabulated windows.

It is not possible to print the Records Window list of records directly. You must use a Query and print its Result Set.
However, that is quite easy.

In the Records Window on the Individuals tab use Lists > Configure Record Window Columns... or right-click on any header and choose Configure Columns... just as you did to add the Ahnentafel column.

At the bottom of the Configure Columns dialogue, there is a Save to Query... button.
Click that and choose a memorable Query Name and close all dialogues.

Now use the main menu Query > All Custom Queries... and select and Run your new Query.
Again clicking on the Ahnentafel column header will sort into order.

To print just those records with an Ahnentafel number needs an extra step.
So when you have got this far ask again.

[Baysig8]

Hi Mike,

Appreciate your prompt (and effective) steps.

I have managed to print out the report (with 7 x columns) and I would be very happy to have the extra step you mention to print just the name and Ahnentafel number columns (2 x columns).

is that what you meant?
Thanks again, Lorraine

[tatewise]

I'm a little surprised that you have Ahnentafel Numbers as large as 14,459.
That suggests you have traced all your direct ancestors back nearly 23 generations to about 1400 AD.
So the screenshots below review what your Query should contain.
With the Query open, it has several tabs across the top such as Columns, Rows, and Result Set shown below.
For further advice see the FHUG Knowledge Base for An Overview of Queries.

This 1st screenshot shows the Columns tab Expressions. Use the X Delete button to remove any unwanted Columns.
I've included Record Id as that uniquely identifies records, to differentiate people with the same name.
The Ahnenetal Number is calculated relative to the Project File Root person (but there are other options).
It is also Sorted in Ascending order.

AhnentafelColumns.png (47.83 KiB) Viewed 1179 times

The 2nd screenshot shows the Rows tab filter that only includes ancestor records with an Ahnentafel Number.

AhnentafelRows.png (35.53 KiB) Viewed 1179 times

The 3rd screenshot shows the Result Set from running the Query.

AhnentafelResults.png (60.1 KiB) Viewed 1179 times

[Gowermick]

I think you got your arithmetic wrong Mike.
14459 is in the range 8192 to 16383, which is the range for 12' GGParents

Out of Interest, my highest is 156770, my 15'GGFather, born c1520

[ADC65]

I actually make it 11x GG Parents, unless I've misunderstood the way it works:

1 = Self
2-3 = Parents
4-7 = Grandparents
8-15 = 1x GGP
16-31 = 2x GGP
32-63 = 3x GGP
64-127 = 4x GGP
128-255 = 5x GGP
256-511 = 6x GGP
512-1023 = 7x GGP
1024-2047 = 8x GGP
2048-4095 = 9x GGP
4096-8191 = 10x GGP
8192-16383 = 11x GGP
16384-32767 = 12x GGP
32768-65535 = 13x GGP
65536-131071 = 14x GGP
131072-262143 = 15x GGP

[tatewise]

Yes, sorry, my quick calculation went wrong somewhere, but it is still 13 generations, which implies tracing most direct ancestors back to nearly 1600 AD.

[LornaCraig]

I wonder if Lorraine meant that the highest ahnentafel number she has is 14,459? That's very different from having traced14459 direct ancestors.

Incidentally it was not necessary to start by creating a query from the Records window configuaration. The standard Ancestors query includes a column for ahnentafel numbers, and also (quite usefully) columns for the generation number and the Relationship description. It can be saved as a custom query so that the additional columns can be deleted, as previously described by Mike, if they are not wanted.

[tatewise]

The OP says "All 14,459 of them". ( I have a suspicion that Lorraine is actually looking at Record ID by mistake. )
Lorraine had already added Ahnentafel Number to the Records Window so seemed a good place to start.
The standard Ancestors Query also can include people without Ahnentafel Numbers, so they still need to be removed using a Rows tab filter, as well as removing unwanted Columns.

[Baysig8]

Thanks to everyone who replied. I will use your suggestions with gratitude!
Re your Ahnentafel comments….
1. Family Historian (7) Ahnentafel numbered my direct ancestors. I don’t believe they made an error, according to my knowledge of this system.
2. Yep, Ahn# 14,459 is an 11xgreat grandmother, born 1550.
3. I do have 12xgreat direct ancestors…but not yet enough proof. Family Historian tells me their numbers will be 29088 and 29089.

As you said, Mike T, my error was in using the word “all”. I was thinking ahead to when I would need to print “all” 14,459 (and hopefully beyond).
So nope, was not looking at the ID numbers.
Thanks for your musings, support and knowledge, Mike, Mike, Lorna and Satyricon.