Multiple referecne [A ID].[B ID].[C ID]


For some advanced App, I have around 10 tables. Some of them relates to another one that relates to another one and so on.
Let’s say I have Table A that refers to Table B that refers to Table C.
In Table A, if I need an information from Table C, I have to create a virtual column in Table B to make that bridge.
It would very nice if I could just write in Table A this formula : [A ID].[B ID].[C ID]


This will be available in some weeks as stated in this Office Hours:

“nested derefs”

@Steve could you please set this to solved?



Wow. This is the best feature I’ve discovered yet! Powerful!