@lbrannon
I just ended up doing temp tables. I have since figured out pass-through queries but I never went back and changed these ones and don't know if that would have solved the issue. On glancing on this old post, I can say that you cannot write a pass-through that joins local tables to linked tables.



I think ItsMe is right that you'd want to open a new thread.