Jump to content


Photo

Married name list


  • Please log in to reply
3 replies to this topic

#1 Clarinetter

Clarinetter

    Advanced Member

  • Members
  • PipPipPip
  • 36 posts

Posted 24 July 2019 - 07:17 AM

In my 'dreams' I would be able to produce a list in custom reports which showed not only the maiden names of married women but their married name (or names if they married more than once)

 

The reason I should like such a list is because to obtain Wills for such individuals one needs to know the surname under which it would be registered. As Wills have just been reduced from 10GBP to 1.5GBP online I imagine several of us will want to order a batch.

 

Any ideas? Could it go on tne next version?

 

*** EDIT - Marriage List seems to work OK but useful to have a way in custom reports.


[Using RM (UK) version 7.5.7.0 as at 24th July 2018]


#2 zhangrau

zhangrau

    Advanced Member

  • Members
  • PipPipPip
  • 1504 posts

Posted 24 July 2019 - 09:08 AM

Is GBP = Great Britain Pound ?



#3 Trebor22

Trebor22

    Advanced Member

  • Members
  • PipPipPip
  • 179 posts

Posted 24 July 2019 - 09:53 AM

Is GBP = Great Britain Pound ?

Yes!      - a recent and I would say a very welcome change to the price of a will.



#4 Kamolga

Kamolga

    Advanced Member

  • Members
  • PipPipPip
  • 69 posts

Posted 28 July 2019 - 12:30 PM

Hi,

 

I use SQLiteSpy to assign married names to all women that are in couples other than partners, so the list of married names is huge in my case since I never forget to assign them....filtering on location could be a good start.

 

Still with this software, you can extract married names only

--List of married Name only
 DROP VIEW IF EXISTS vMarried;
 CREATE TEMP VIEW vMarried AS
 SELECT OwnerID,
        Surname,
        Given
 FROM NameTable
 WHERE NameType=5;
SELECT * FROM vMarried

and copy-paste in Excel if you want to design a report.

 

The following query gives you all alternative names of women having a married name in your database (even spellings, immigrants, and so on)

--List of all names of women having a married Name
 DROP VIEW IF EXISTS vMarriedFull;
 CREATE TEMP VIEW vMarriedFull AS
 SELECT OwnerID,
        Surname,
        Given
 FROM NameTable
 WHERE OwnerID IN(
                  SELECT OwnerID
                  FROM NameTable
                  WHERE NameType=5);
Select * FROM vMarriedFull

Rootsmagic 7.5.9.0 with a lot of SQL queries (SQLiteSpy) and a bit of Family Historian 6.2 (tree view and map)