Referencing column showing the reference code rather than the reference name when I use it in a declaration

I have this expression in my SHOW column.

The language is taken from a paper from.

“I " & [Inspected By] & " declare that the abovementioned goods were inspected by me as per the inspection form on the reverse side to this document and I declare to undertake the following actions (mark with an X):”

The [Inspected By] column is a reference column. In the drop down for the question inspected by I get the names rather than their unique IDs.

But in the declaration above I get the Unique Ids. How do I get the declaration to show the name and not the ID?

The [Inspected by] is not the label or key.

1 Like