Virtual Column: Select data from a table to put in a second table as virtual column

[Reynieri_Vargas]

I have two tables:

First table contain

Second table:

I want to create a virtual column in the second table that contains the name of the representative of the first table that corresponds to the ID_Agroservice of the first table.

I think it should not be so difficult but I am new to this app.

I would appreciate your help in the formula that should be used.

I am using this formula but it only gives me a Yes/No expression

Thanks for your support!!

[Joseph_Seddik · Accepted solution]

Welcome to the community!

You should rather be using a normal column with a dereference expression.

[ID_Agroservice].[Representative]

Dereference Expressions | AppSheet Help Center 

[Reynieri_Vargas]

Thanks, very useful your advise!!!