Slice Filter and dependent results

[Yeyo1976]

I have a problem that I haven't been able to solve. I've looked around here and in other forums, but I haven't found an adequate answer.

I have a table called Bitacora, which has the following structure 

The form has this structure

The 'alumno' field is referenced to a slice to display only the records associated with a useremail

 What I need is for the 'Nombre Apoderado' and 'Email Apoderado' fields to be populated with the data corresponding to the previous selection. For example, if I chose Hija 2, then shows me Hija 2 fathers name and email.

I tried using the Lookup function, but it didn't work (at least not for me).

I tried using dependent references, but it's not working for me 100%, since I have to select the guardian first and then the student, which is an unnecessary extra step

Please help me.... 

[lynchk21 · Accepted solution]

If 'Nombre Apoderado' and 'Email Apoderado'  are on the same table as your table referenced by 'Alumno', you can use the dereference expressions [alumno].[Nombre Apoderado] and [alumno].[email Apoderado] 

If 'Nombre Apoderado' and 'Email Apoderado' are on a different table, you can use lookup as long as that table also has a Alumno column to use in your condition: Lookup([_thisRow].[Alumno],"Table Name","Alumno","Nombre Apoderado")

[lynchk21 · Accepted solution]

If 'Nombre Apoderado' and 'Email Apoderado'  are on the same table as your table referenced by 'Alumno', you can use the dereference expressions [alumno].[Nombre Apoderado] and [alumno].[email Apoderado] 

If 'Nombre Apoderado' and 'Email Apoderado' are on a different table, you can use lookup as long as that table also has a Alumno column to use in your condition: Lookup([_thisRow].[Alumno],"Table Name","Alumno","Nombre Apoderado")

[Yeyo1976]

Thanks!!!

Second choice works fine. 

I have another question, maybe a bit silly.

I have two related tables (Alumnos and Apodreados). They are structured in such a way that when I enter a new guardian, I can also add a new student.

Why is this happening if I have the KEY in the Apoderado RUT (unique number) and the Label in the Apoderados name?

[lynchk21 · Accepted solution]

Reference type columns use the key column. In your Alumnos table you should set Rut Apoderado as a REF type and then use [rut apoderado].[nombre] to get your [nombre apoderado] value. Your label value will still display in the app for the reference column