* Setting surname of wives to maiden name (v5)

[rfj1001]

I've got about 6500 people in my tree and I record all variant spellings of names together with their sources.

Over time, the visible (ie primary) surname of a wife may have drifted from a (variant) of her maiden name to (a variant of) the husband's surname.

Has anyone got any thoughts how I might try to isolate the records that I need to look at further (I appreciate the final change will almost certainly have to be done manually.)

Thanks

Rob

ID:6128

[Jane]

Rob,

I think where I would start is a Query listing all the Women, (perhaps the old married women query).

Then add columns for the multiple name fields (just the surname).

You can then jump to the Property box and sort them.

If there are lots of repeated ones on V5 you could write a plugin to for example find all the MULLINS surnames and make them the primary name if they exist.

[rfj1001]

Hi Jane,

There's another query you wrote looking for surname pairs. If I set both surnames the same, the result set gives me records I know I need to change (albeit I get two records returned for each marriage, which is no big deal).

However, if I used this way for the rest, I'd have to run the query for every surname spelling directly which would be a big drawback and not very practical.

In terms of the query language, could it cope with returning a record set where a husband's primary surname matches a wife's primary surname. I guess, if that could be done, it would reduce the scale of the problem significantly.

If so, can you give me the gist of the syntax to get me started.

Thanks as ever

[tatewise]

The Row Filter could be something like:

Condition:   Add if
Expression: =IsTrue(%INDI.NAME:SURNAME% = %INDI.~SPOU>NAME:SURNAME%)
Operator:    is true

[rfj1001]

Thanks Jane - works a treat

[tatewise]

That's good - but I am Mike Tate not Jane!!!!