Problem with ref tables

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.

Yeyo1976_0-1713964856756.png

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)

Yeyo1976_1-1713964970135.png

The table Padre has this structure

Yeyo1976_2-1713965042930.png

And the ref from Alumos Table is this

Yeyo1976_3-1713965123091.pngYeyo1976_4-1713965157889.png

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

Padres Table

Yeyo1976_5-1713965235096.png

Alumnos Table

Yeyo1976_6-1713965282075.png

It's drive me crazyyyyy

Solved Solved
0 7 106
1 ACCEPTED SOLUTION

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.

View solution in original post

7 REPLIES 7

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.

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

Yeyo1976_0-1713982555185.png

 

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

In the "Valid if" formula

Hi, thanks for your time!

No, I don have any formula 

 

Yeyo1976_0-1713985604413.pngYeyo1976_1-1713985620080.pngYeyo1976_2-1713985626321.png

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

Table Usuarios ref to a table Roles.

Yeyo1976_2-1713986699902.png

Yeyo1976_1-1713986677320.png

Yeyo1976_0-1713986619556.png

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

Yeyo1976_3-1713986951792.png

 

 

 

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

Yes, it's the ID Role for Profesora

Yeyo1976_0-1713987837319.png

 

Top Labels in this Space