Home Page list
Alternate Names List
I created alternate names for wives so I can find the wife with her married name.
I put the given and maiden name in the given for the alternate name. I put her husband’s surname in surname. I use Married as Name Type, Mrs. As Prefix and the husbands given name with parenthesis around it as the suffix.
I am using the following query to get the alternate names: (See Pic 1)
It works great if there is only one alternate name. It is a problem if there is more than one alternate name for each husband as displayed in Pic 1.
This is the print screen of Rootsmagic. (See Pic 2)
If I do a data view of the nametable and do a custom on ownerid of 590, I get the following: (See Pic 3)
If I do a data view of the familytable and do a custom on ownerid of 590, I get the following: (See Pic 4)
How do I get the original query to display the correct husband with the wife like displayed below? (See Pic 5)
I copy all of the results of the query into a spreadsheet to verify there aren’t any typos in the alternate name. (See Pic 6)
Is it possible to create the query to get the results contained in the spreadsheet? (Column O and Column P)
How could I put a where statement in thee query to select only certain ownerid's? I need to be able to hard code it and to be able to input the ownerid.