FAMILY-HISTORIAN-USERS-L Archives

Archiver > FAMILY-HISTORIAN-USERS > 2004-06 > 1088060880


From: Mike Shingleton <>
Subject: Re[2]: [FHU] Queries - Married Names
Date: Thu, 24 Jun 2004 08:08:07 +0100
References: <260275A22EDB3443917B88084B71024112ECDB@mailgate.mi-casa.co.uk>
In-Reply-To: <260275A22EDB3443917B88084B71024112ECDB@mailgate.mi-casa.co.uk>


John,

I would like a query which brings up anyone with the same surname.
I had imagined that it would be easy but then came the married name
issue!

In other query languages I have used this would be equal using an 'OR'
type function but I don't understand how to bring up all men named
SMITH and all women whose married name is SMITH. That should give me
a list to check against the death certificate indexes at FRC.

Surely it should be fairly straightforward.

I'll have a play around with the data references you mention.

Thanks and regards,
Mike mailto:



On Thursday, June 24, 2004, 1:17:40 AM, you wrote:

This might be over-complicating things a little, but your query requirements probably need a little further clarification, before one can start to suggest something that would suit your needs.

Do you only want to see people that are dead, or people that are "likely" to be dead, irrespective of whether you have an event that could indicate that they are dead (i.e. buried, cremation, etc.).

In any eventuality, if you're just looking for some pointers, then the types of data references that might be of interest (dependant on the exact requirements), might be:

INDI.NAME[1]:SURNAME
INDI.SEX
INDI.FAMS[1]>WIFE>NAME[1]:SURNAME
INDI.DEAT[1]

Note that here we immediately start to see some complications, such as individuals with more than one recorded surname (.name[]) as well as multiple spouses (.fams[]). You can simplify by ignoring these complications, but you may then not get all the records that you might be interested in.

All of these things can be dealt with, once you have a clear idea of what you are trying to achieve; at which point sensible suggestions could be made for how you might filter down to the required records, based on the fields selected.

The only other suggestion worth making, at this stage, is the one that has recently already been made; namely that one can learn a lot by studying how other queries work.

John
http://thewheatleys.com

> -----Original Message-----
> From: Mike Shingleton [mailto:]
> Sent: 23 June 2004 17:37
> To:
> Subject: [FHU] Queries - Married Names
>
>
> Hello,
>
> I'm new to Family Historian and especially the queries.
>
> Whilst I have found FH a doddle to enter data in to I'm
> struggling a little with the custom queries.
>
> Whilst at the FRC yesterday I noted the death certificate details
> for a number of people with the same surname.
>
> I would like to create a query to call up everyone with this
> surname. However the problem arises in that I want everyone with
> this surname at the time of death - in other words including
> whose married name equals this surname.
>
> Can anyone offer a newbie some advice on how to do this - I'm
> tearing my hair out!
>
> --
> Best regards,
> Mike
>
>
> ==============================
> Gain access to over two billion names including the new
> Immigration Collection with an Ancestry.com free trial.
> Click to learn more.
> http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
>
>
> ---
> Incoming mail has been virus checked.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.703 / Virus Database: 459 - Release Date: 10/06/2004
>
>

---
Outgoing mail has been virus checked.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.703 / Virus Database: 459 - Release Date: 10/06/2004



==============================
Gain access to over two billion names including the new Immigration
Collection with an Ancestry.com free trial. Click to learn more.
http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237


--

This thread: