* Custom Relationship Expressions for Report(s)

[Gary Carson]

Parameters
File Root = Marilyn Marie CAULK
File Owner = Gary Carson

Custom Relationship Expressions for Report(s)

=Relationship(FileRoot()) to %CUR_FILE_ROOT% returns “half 1st cousin 7 times removed to Marilyn Marie CAULK”. This is correct.

=Relationship(FileRoot(),%CUR_FILE_OWNER%,,) to %CUR_FILE_OWNER% returns “=Relationship(FileRoot(),%CUR_FILE_OWNER%,,) to Gary Carson”. This is not as intended. It should return “wife's half 1st cousin 7 times removed to Gary Carson”

How do I correct =Relationship(FileRoot(),%CUR_FILE_OWNER%,,) to %CUR_FILE_OWNER%

[tatewise]

It is not possible to get that to work because %CUR_FILE_OWNER% does not refer to an Individual record.
Notice how the surname is not capitalized.
It refers to a plain text Name field in the Submitter record, i.e. =Field(Record(1,"U"), 'SUBM.NAME')

[Gary Carson]

How should I write the expression to relate to specific individual?

[tatewise]

Use Record(123,"I") to refer to Individual record with Record ID 123

=Relationship(FileRoot(),Record(123,"I"),,) to =Record(123,"I")

[Gary Carson]

As always, thanks.