Hi there Steve
With you calculated result do you just want it to show one related record, a Spouse or a Partner, or list them all in the format you describe?
And if just one, which one if there are multiple?
Based on the format you describe try this calculation, you could place it in the RELATIONS record and it will calculate for each person and you can use this field to displayed on the CONTACT record depending on how you want to do this.
If ( RELATIONS::relationship = "Spouse" and CONTACT::lastName = RELATIONS::lastName ;
CONTACT::firstName & " and " & RELATIONS::firstName & " " & CONTACT::lastName ;
CONTACT::firstName & " " & CONTACT::lastName & " and " & RELATIONS::firstName & " " & RELATIONS::lastName
This is exactly what I am looking to do. Thanks so much for your help.
I will rank spouse first and then partner second.