Reference chosing the wrong column?

[Steve_Fuller]

I have an App that is working well and I have no issues with its working or references to other table’s data, which display as I expect.

However, I’ve recently begun using PDF templates to email list (Parent Child Data) and have a problem.

The text displayed is the Index column and not the Ref column.

The Ref is set up as

Which I assumed took its Ref from the SAME NAME in the linked table (ie Level 02 Name)

In the App Level 02 Name is displayed correctly as 25K/26T/MCC/1

But in the email it displays the key 7jgmnjPn

Anyone suggest how I can overcome this please?

Thanks in advance