* Display Relation to Root in a Named List Report

[Johnyeates]

Is there some way of adding a column to a custom 'Named List Members' report showing their relationship to the 'Root'.
All I can display is the 'Root' persons name against everyone in the report.
Thanks
John

[PeterR]

Have you tried:

Code: Select all

=Relationship(%CUR_FILE_ROOT%,%INDI%,TEXT,1)

as a Column Expression for the Custom Query?

[Johnyeates]

Thank you, it works fine.
I couldn't have worked it out myself.
John