Problem with ref tables

[Yeyo1976]

Hi, I have, perhpas, a silly question.

I have 2 tables (Padres and Hijos).

I need that from Padres table you can add new Hijos, and I did it.

The problem is when the new view is open (Alumnos form), shows me the fathers name instead Rut Apoderado (its the key because its a unique number)

The table Padre has this structure

And the ref from Alumos Table is this

But, in the data base, they show the correct data in each column

Padres Table

Alumnos Table

It’s drive me crazyyyyy

[nicolasfsamaja]

When you set a value as label, it shows you the name instead of the code. That is why.
Switch the label to RUT just for underestanding.

[Yeyo1976]

I did what you say to me, it’s work fine, but in the nested table shows a yellow rectangle

[nicolasfsamaja]

Maybe you have a select or similar, looks like that value should not be there

[nicolasfsamaja]

In the “Valid if” formula

[Yeyo1976]

Hi, thanks for your time!

No, I don have any formula

For example, in other aplication I have this issue (similar)

Table Usuarios ref to a table Roles.

With IDRoles as key, in the data base show me the ID Role, not the Role

[nicolasfsamaja]

Check if that code is in the database, sounds like that code is not an option.

[Yeyo1976]

Yes, it’s the ID Role for Profesora