Why the condition in my select non function?

Gonzzo
New Member

These are my tables:
Buisness(Empresa) table:
3X_3_1_31bdf356ad17d944a08ddec7ae60a3730db5bfbc.png

IQ table:
3X_0_a_0a2c411fb8353e2dae34ec89e0dbdf1614177558.png

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?

Solved Solved
0 4 185
1 ACCEPTED SOLUTION

You just need to de-ref it:

[Empressa].[Nombre]

View solution in original post

4 REPLIES 4

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.

Show just one name of empressa from table Empresa

You just need to de-ref it:

[Empressa].[Nombre]

THANK YOU! Whit this base i will continue my work

Top Labels in this Space