Dereference a dereferenced table

[Rachel_Anne]

Can I dereferenced a derefenced table?

[WillowMobileSys]

If you mean something like [Table A Ref].[Table B Ref].[Table C Column], unfortunately no we cannot dereference several levels.

[Rachel_Anne]

Thanks a lot for responding. Okay got it

[GreenFlux]

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.