* Conditional Text for Witnesses

[D-W]

I was hoping to use {=TextIf(%FACT._SHAR[1]>SEX%= "Male", "wife", "husband")} in the following witness sentence:
'...to visit {him/her} and {his/her} {=TextIf(%FACT._SHAR[1]>SEX%= "Male","wife","husband")}' where the Witness was the person being visted to return:
'...to visit him and his wife.' if the witness was male and
'...to visit her and her husband.' if the witness was female.
However, although this works for male witnesses, it returns '...to visit her and her wife.' when the witness is female!
I would appreciate any help in getting the syntax right.

[tatewise]

Yes, that is quite a tricky scenario.

Your problem is that FACT._SHAR[1]> refers to the 1st Fact Witness who might not be the current witness.
So use the shortcut CUR~WITN> which always refers to the current witness.
See the Help for Understanding Data References.

Better than testing the SEX field I advise using the =Sex(...) function:
{=Sex( %CUR~WITN>%, "wife", "husband", "partner")}

[D-W]

Thank you Mike. Once again you have come to my rescue. I found that both your proposed solutions worked.