Lookup field renders incorrectly (ID instead of value) when used in record template
I have a custom record template I send using sendmail as an attachment on button click in a report's record.
Most of the fields show up correctly but one field which in the corresponding form is a lookup to another table shows the IDs instead of values. Any idea how to fix this? See the last row "Products of Interest".