* adding generation number to a query

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
User avatar
Deirdre784
Famous
Posts: 157
Joined: 12 Mar 2016 14:55
Family Historian: V7
Location: Cardiff

adding generation number to a query

Post by Deirdre784 » 30 May 2023 16:57

Before I go mad, please can someone tell me how to display generation numbers in a query? I have hunted through the kb and searched the forums, and read through the query chapters in the book.

I created a custom query a few years ago to print a list of ancestors to add to the front of a binder of certificates. Had columns of name, relationship, generation, birth date, mother, father, death date. Preparing another binder now, I added place of birth to the query, but it was too wide to print nicely, so deleted it but somehow deleted generation too. Now I cannot find out how to add it back in. Without it, my list is jumbled, or if sorted by relationship separates mother and father by loads of grand and greats :(
Deirdre

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

Re: adding generation number to a query

Post by tatewise » 30 May 2023 17:26

I've moved this to the General Usage forum as it fits better there.

The one thing you have not checked is FH itself.
Try the Query > Relatives and Relationships > Ancestors and plagiarise its Generation column.

May I suggest you use one of the Backup and Restore Family Historian Settings plugins to preserve your customisations?
Then you can restore old custom Queries, Diagrams, Reports, etc.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
Deirdre784
Famous
Posts: 157
Joined: 12 Mar 2016 14:55
Family Historian: V7
Location: Cardiff

Re: adding generation number to a query

Post by Deirdre784 » 30 May 2023 18:11

Thanks Mike, as always. Not sure now where I put the post but thanks for moving it.

I thought I looked at all the 'relationship' queries but clearly didn't see that sorry; i did actually get as far as entering =RelationCode but couldn't then work out what to add after that.

I do backup my projects but have never needed to do a restore so didn't think of that option.

Going off to hide now :(
Deirdre

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

Re: adding generation number to a query

Post by tatewise » 30 May 2023 19:53

I'm not sure if you understood my suggestion.
Project Backups do not save Queries, Diagrams, Reports, etc. So restoring them will not get custom Queries back.
You must use one of the Backup and Restore Family Historian Settings plugins from the Plugin Store.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
Deirdre784
Famous
Posts: 157
Joined: 12 Mar 2016 14:55
Family Historian: V7
Location: Cardiff

Re: adding generation number to a query

Post by Deirdre784 » 30 May 2023 21:45

Thanks Mike, yet another thing I didn’t know.
Deirdre

Post Reply