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.