The original question. How can I find the married women for whom I have not
added an AKA? I want to add an AKA for them with their married name.
Logically, a search looking for "married females with a blank Alt Surname"
should return those with all married females with no Alt Surname. However,
since this is a relational database, I understand why that does not happen
(based on a prior e-mail with the explanation).
This suggestion works and is the only thing I can get to work:
tag1 all females with MRIN > 0
tag2 individuals with alt surname wildcard ?*
then search for everyone with tag1 and not tag2
I followed this suggestion and have updated those reported whom are truly
married (and left the unmarried with children as they were - with no AKA).
Thanks from Sharon Perdue to Dennis M. Kowallek for this solution.
----- Original Message -----
From: "C.G. Ouimet" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, August 26, 2005 10:45 AM
Subject: Re: [LegacyUG] search question
So, perhaps a search looking for individuals with blank Alt Surname should
return those plus individuals without Alt Surname fields, two different
things from a database structure perspective but the same thing from a
user's data perspective.
At 2005-08-26 12:05 AM, you wrote:
C.G. Ouimet wrote:
... It's as if the fields Alt Given Name and Alt Given Surname fields
only exixt for those individuals where at least one of Alt Given Name and
Alt Given Surname is actually in use ...
That is exactly the case, If you have not entered either an alt given name
or an alternate surname the field does not exist. (This is the way
relational data bases work, the link between a person and an alternate
name is in a separate table and only people with alternate names have
entires in that table. That saves storage space since only those people
with alt. names use the storage apace for an alt name and that is how you
can enter more than one alternate name for the same person, it is just an
extra entry in the alternate name table.) That is why searching for alt
names only gives you the individuals that have one or the other.
To get the 80,000 who have no alternate name. Use a search for alt given
name = wildcard OR alt surname = wildcard. this should give you everyone
in your file with an alt. name entry.
Tag everyone in the search list with a tag you know you have not used (say
6) or first use the advanced tagging to clear a tag then tag everyone in
the search list with that tag.
Repeat your search and this time look individuals where the tag you used
earlier is untagged. Now all the people without an alternate name will be
returned.
Brian Kelly
Rockland, ON
Legacy User Group Etiquette guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
To unsubscribe please visit:
http://www.legacyfamilytree.com/LegacyLists.asp
C.G. Ouimet
Kingston, Ontario
Legacy User Group Etiquette guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
To unsubscribe please visit:
http://www.legacyfamilytree.com/LegacyLists.asp
Legacy User Group Etiquette guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
To unsubscribe please visit:
http://www.legacyfamilytree.com/LegacyLists.asp
