Different reference value in database(Source)

[Peter_Benatti]

Hello everyone,
I’m trying to use reference in a column of the source for a list in the report. But the result appears a number and the value.
How do I show only the data value in the source?
EX: FL RECIFE
AND NOT 112FL RECIFE

watch the ‘DESTINO’ column

“I found that I can put UNIQUEID() for key, I was using concatenate, will be alterate”

[Marc_Dillon · Accepted solution]

Peter_Benatti:

I’m trying to use reference in a column of the source for a list in the report. But the result appears a number and the value.
How do I show only the data value in the source?

“I found that I can put UNIQUEID() for key, I was using concatenate, will be alterate”

I really can’t interpret any of these 4 sentences. But judging from some key words you used, maybe you need to review the following help articles?

help.appsheet.com

References Between Tables

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

help.appsheet.com

What is a Key?

Learn the purpose of keys and why they’re necessary.

help.appsheet.com

Row Labels

How to determine which columns are prominently displayed in a view.

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

[Peter_Benatti]

wow, its work.
i need use a key colum.

References Between Tables