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 RELATED fuction work with a direct query?
The error is "either doesn't exist or doesn't have a relationship to any table available in the current context."
RELATED won't work across limited relationships, so if the 2 tables are on different data islands you'll need to use LOOKUPVALUE instead.
