* Birthdays (For given day + Month) + Relationship to Someone

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
dbridge276
Platinum
Posts: 34
Joined: 16 Jun 2003 20:15
Family Historian: V7
Location: Rayleigh, Essex, England
Contact:

Birthdays (For given day + Month) + Relationship to Someone

Post by dbridge276 »

I would like to amend the Standard Query that lists all the birthdays for a given Day and Month so that I can apply this to a Family member to show which family members share the same Birthday and how they relate to each other.

I cant get the query to include the relationship.

What would i need to add to the existing Current Query to get a Relationship defined please.
Researching Bridge, Renwick, Parsons, Child, Everett + my wife’s side of our tree Carney/Street, Curtis, Weight, Rush
User avatar
tatewise
Megastar
Posts: 28344
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Birthdays (For given day + Month) + Relationship to Someone

Post by tatewise »

Here is a clue.
In the Records Window there is a Column called Relationship to Root.
If you investigate how that is composed you will be able to do something similar in the Query Columns.

I presume you have already used Save As Custom Query and replaced the prompts for Month and Day with a prompt for the Individual family member whose Birth Date is to be matched.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
Jane
Site Admin
Posts: 8508
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: Birthdays (For given day + Month) + Relationship to Someone

Post by Jane »

I think this will do what you want, it will prompt as before, but also ask for a selected member to show relationships for.

To show how everyone is interrelated in one run would probably need a plugin.
Attachments
Birthdays (for given day and month) with relationship to selected person.fhq
(1.51 KiB) Downloaded 172 times
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
User avatar
tatewise
Megastar
Posts: 28344
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Birthdays (For given day + Month) + Relationship to Someone

Post by tatewise »

The attached Query just prompts for the Person and lists everyone with the same Birth Date day & month as that person, together with their relationship to that Person (if any).
Those without a family relationship could easily be excluded if required by adding Rows tab filter:
Exclude if =Relationship(["Person"],,TEXT,1) is null

As Jane says, listing the interrelationships between everyone listed would be tricky.
Attachments
Birthdays for given day and month with Relationship.fhq
(1.63 KiB) Downloaded 186 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
dbridge276
Platinum
Posts: 34
Joined: 16 Jun 2003 20:15
Family Historian: V7
Location: Rayleigh, Essex, England
Contact:

Re: Birthdays (For given day + Month) + Relationship to Someone

Post by dbridge276 »

Thank you Jane & Mike.

They both satisfy a need.

Jane's is actually spot on with what i was after,
the ability to put any month and day in and get the individuals returned and their relationship to me or any other individual selected from the FH Database.

Mikes one is not wasted either.

goes to show there is always more than 1 way to skin a cat with FH queries.

Thank you both
Researching Bridge, Renwick, Parsons, Child, Everett + my wife’s side of our tree Carney/Street, Curtis, Weight, Rush
Post Reply