Why the condition in my select non function?

These are my tables:
Buisness(Empresa) table:
table buisness

IQ table:
table IQ

The virtual Column from IQ table:

I put the condition ([Empresa]=[_THISROW].[Empresa]) but it didn’t function.
Why the condition show all names(nombre from Empresa)?
How to repair my problem?

The [Empressa] column in IQ table is a REF column to Empressa table. So the [Related Empressa] virtual column should already have a REF_ROWS() expression. I couldn’t quite get what you are trying to achieve here.

1 Like

Show just one name of empressa from table Empresa

You just need to de-ref it:

[Empressa].[Nombre]
2 Likes

THANK YOU! Whit this base i will continue my work :smiley:

1 Like