Select extra info from another table in pdf file

Hi
I am trying to get the address of the shipping place from the table shipping while i am exporting order report but I am not able to, do i have error in my syntax? need help

SHIP TO:
<<[ShippingTo]>> (returns value because it is getting value from the order table)
<<Start: LOOKUP( [_Thisrow].[ShippingTo] , ”Shipping”, “ShippingTo” , “Address” )>><> (returns nothing)

1 Like

I would suggest investigating references, they’ll allow you to connect tables together and pull data easily from one to the next.

So the [Shipping To] would be a reference to the Shipping table, then you could dereference the Adress super easy:

[Shipping_To].[Shipping_Address]

1 Like

Thanks it works now :slight_smile:

2 Likes