PDF report issue

I have created a PDF report for email, its working good, but I have only one issue

INVOICE

 Bill: <<[TAN]>>                                                                                                  Date: <<[Date]>>

  Customer: <<[Customer]>>

  Truck: <<[Truck]>>

   Coupon No.: <<[Coupon No.]>>

Here my customer is showing as a number only, this is because I have done this through an “enum” reference from “another sheet”. any one sugguest me a solution for this

Maybe

Customer: <<[Customer].[Customer Name]>>

Where [Customer Name] is the customer name column in the referenced parent table.

2 Likes