Select extra info from another table in pdf file

[ihayek86]

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 · Accepted solution]

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

help.appsheet.com

Search results for: references

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

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]

Thanks it works now