10
How can I display a field from a related table via Lookups.
My current table is TableA that has (M:1) with TableB, TableB has (M:1) with TableC (which contains the Description field ).
Why doesn't this work:
ThisItem.'TableA Lookup'.'TableB Lookup'.'DescriptionField'
Hi @s-roberts :
It is not feasible to continuously refer to related entities like this.
Please try this code:(I assume 'Name' is TableB's primary key)
Share
Report
All responses (
Answers (
LookUp(TableB,Name=ThisItem.'TableA Lookup'.Name).'TableB Lookup'.'DescriptionField'
Maybe this post can give you some inspiration:
Best Regards,
Bof
