Dereference a dereferenced table

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.

2 Likes