Record sources the query wizard cannot connect...

[Paul (ESI)]

I am trying to create a query from two tables and another query. I got the
following error message:

"You have chosen fields from record sources which the wizard cannot connect.
You may have chosen fields from a table and from a query based on that table.
If so, try choosing fields from only the table or only the query."

The thing is, this isn't true. The query isn't based on either of the tables
I'm using. Also, when looking at the existing query used in my new query, it
also DOES NOT use either of the tables. The two tables I'm using as part of
the query are not involved. Why will it not let me do this? As far as I can
tell, the relationships are set up properly. Any help would be greatly
apreciated. I'm using Access 2002, and my colleague working on this with me
is using 2003. Same error message on both versions.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

 

[Paul (ESI)]

Darn! I guess maybe I found a rather difficult problem, because apparently
nobody knows the answer. I've found, typically, if somebody knew the answer
they'd have posted it by now. Well, thanks anyway, folks. I can honestly
count on one hand the amount of times nobody could answer my question, so I
sure as heck cannot be disappointed.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy