Bizarre Parameter problem

[TroyMcClure]

I made a quick query, saved it as 'query4', just because it was only to be a temporary make-table query. I made a table called 'SomeTempTable' using query4. I then deleted query4

Then I made another select query (called 'query10') using 'SomeTempTable' as it's source. When I run Query10, it pops up a parameter box asking for Query4.Difference.

'Difference' is one of the fields in the table 'SomeTempTable'.

I looked in the SQL of the query10, and there is NOTHING about query4, there are NO parameters in the parameter list for query10. I've compacted the databse also. I still get this. How in heck does 'query4'--which is totally deleted and wiped clean from the entire databse--even referenced at all???
T

 

[gwog]

Is it possible that when creating the SomeTempTable from query4 - there were two fileds named difference - so it created two fields in new table and named them query4.difference and somethingelse.difference?

don't know if that helps or not - but just 1st thought that came to my mind.

 

[TroyMcClure]

gwog,
Thanks for replying. No, there weren't 2 fields, I checked the original source of the make-table query, and the result. I think it has to do with the MSys tables--whichever one holds field info. It just got fried somehow. I did a speed-ferret search and query4 was nowhere to be found. After I deleted Query10, I remade it and all worked fine, so the problem is solved but it was certainly bizarre.
--T