Forum Discussion
Solved
RELATED Function with a Direct Query Table
I am trying to use the "RELATED" function with a Direct Query Table and alway get and error. I have the tables related. Is there an different way to relate to a direct query table? Will the RELATE...
RELATED won't work across limited relationships, so if the 2 tables are on different data islands you'll need to use LOOKUPVALUE instead.
johnt75
Super User
Super UserRELATED won't work across limited relationships, so if the 2 tables are on different data islands you'll need to use LOOKUPVALUE instead.
LOOKUPVALUE also is not working in the direct query mode.