Select extra info from another table in pdf file

[ihayek86 (Ibrahim)]

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)

[MultiTech_Visions]

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

Search results for: references

References Between Tables

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

[Shipping_To].[Shipping_Address]

[ihayek86 (Ibrahim)]

Thanks it works now