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]