Can I dereferenced a derefenced table?
If you mean something like [Table A Ref].[Table B Ref].[Table C Column], unfortunately no we cannot dereference several levels.
Thanks a lot for responding. Okay got it
No, not directly. But you can add a virtual column to the ‘grandchild’ table, that is a reference to the ‘grandparent’ record.
Then you can dereference that column to read any other column in the grandparent table from the grandchild.
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |