How to call data from grandchildren to parent column

Hi everyone,

Is anyone can help me to find a way to call the data in parent table from grandchildren table.

I illustrate the situation below:

Table A:
[ID] <= Key
[Teacher Name]
[Class]

Table B:
[ID] <= Key
[Table A ID] <= Ref to Table A (Is part of)
[Date]
[Time]
[Column 1]
[Column 2]

Table C:
[ID] <= Key
[Table B ID] <= Ref to Table B (Is part of)
[Teacher Name] <= App formula: I need to get the data of column Class from Table A
[Class] <= App formula: I need to get the data of column Class from Table A
[Date] <= App formula: [Table B ID].[Date]
[Time] <= App formula: [Table B ID].[Time]
[Column 1] <= App formula: [Table B ID].[Column 1]
[Column 2] <= App formula: [Table B ID].[Column 2]

Note: I can insert columns [Teacher Name] and [Class] in Table B buat I need to reduce the number of column as much as possible since I want to list all the column in Table C

Thanks for your help.

Chained dereference.

2 Likes

Thanks for the help. May God bless you.