How to display data from another table? Template Code

[Pedro_steffens]

I have a table with two tabs related to each other, "People Table" and "Services Table".

When I generate the Service PDF, it shows the person's ID, but I would like to display other data, such as name and telephone number.

Model Template code:

DATA SERVICE/TIME: << [DATE_TIME] >>

NAME: ???

SUBJECT: << [SUBJECT] >>

ATTENDANT: << [ATTENDANT] >>

[St0n3]

Hi @Pedro_steffens 

You can use a dereference expression. Try: 

NAME: <<[ID_PEOPLE].[NAME]>>

For more information:

Dereference expressions 

[Pedro_steffens]

I've tried

NAME: <<[ID_PEOPLE].[NAME]>>

With Start Expressions I think it's the way, but I can't seem to execute the:

<<Start: Select...??? <<End>> 

[Pedro_steffens]

I can do it using a virtual column and lookup expression, thk

[jaichith · Accepted solution]

Are you pulling child record in PDF?

If yes, your template expression is wrong. 

[Pedro_steffens]

<<Start: Select(PEOPLE[ID], [ID] = [_THISROW].[ID_PEOPLE])>>

<<[NAME]>>

Thank u

<<End>>