* Correct name in Narrative Reports

[Moz]

Elizabeth Smith marries James Brown who dies.
Elizabeth Smith then marries William Green.

How can I get a narrative report to show the correct family name of a previously married woman?
It reports William Green m Elizabeth Smith when she was, in fact, Elizabeth Brown by that time.

The ideal report would show her as Elizabeth Brown (nee Smith).

ID:6548

[tatewise]

Reports use the Primary Name recorded in the Individual Record, which for women is conventionally their Birth/Maiden name.
Workaround:
Temporarily, edit the name of Elizabeth Smith to Elizabeth Brown (nee Smith) as follows.
In her Property Box click the pale blue More (+)... link.
Change her surname from /Smith/ to /Brown/ and insert (nee SMITH) in the Name Suffix box.
Produce the Narrative Report and then change her name back afterwards.

[GladToBeGrey]

How about something like:

Code: Select all

=Text(%INDI.NAME:FIRST% . ' ' . TextIf(IsEmpty(%INDI.~SPOU[last]>NAME%),%INDI.NAME:SURNAME%,Text(%INDI.~SPOU[last]>NAME:SURNAME% . ' (née ' . %INDI.NAME:SURNAME% . ')')))

I've tested it (in a Query) on 0-4 marriages, and it seems to work. Checks for the existence of a last marriage (more accurately, has a surname); if one does, the spouse's surname followed by ' (née Maiden name)' is appended to the woman's FIRST name (with a space between), otherwise her original surname (maiden name) is appended.

This expression does assume the target is female.

[tatewise]

GladToBeGrey,
That expression displays a woman's maiden name if never married, or her last married name.
e.g. Janet MAIDEN or Janet LASTMAN (née MAIDEN).
Where MAIDEN is her maiden surname and LASTMAN is her last husband's surname.

But for Maz, Elizabeth's last (2nd) husband is William GREEN so it produces:
Elizabeth GREEN (née SMITH), which is not what is requested.

The index [last] would need to be [1] in that example, but would be a different value depending on which marriage was being considered.

Furthermore, the expression can be used in a Query Column or Diagram Text Scheme, but I don't see how it can be used in a Narrative Report.

[GladToBeGrey]

Ouch.

Transcription error. Expression should have read:

Code: Select all

=Text(%INDI.NAME:FIRST% . ' ' . TextIf(IsEmpty(%INDI.~SPOU[last-1]>NAME%),%INDI.NAME:SURNAME%,Text(%INDI.~SPOU[last-1]>NAME:SURNAME% . ' (née ' . %INDI.NAME:SURNAME% . ')')))

[last] index references should have been [last - 1].

This works when %INDI% is the subject, not when it's actually the spouse you're looking at.

I'd also forgotten you can't use expressions like this in Narrative Reports - a bit rusty after some time away from doing FH. Nevertheless, it was diverting to attempt a solution.