Losing Joins

[Seti]

I have a situation where the joins between tables in my queries disappear for no apparent reason. This afternoon, I checked a query that had two tables with two joins between the tables. The joins were intact (I saw the lines in the query). A few minutes later, I checked the query (without running anything in between) and one of the two joinss was gone. Has anyone else run into this situation? Any ideas on what happened and/or how to prevent this from occurring in the future? Thanks for any help.

Seti

 

[Joe4]

Odd, I don't why that would be happening unless you weren't saving your changes...

Anyway, did you try setting up the links in Relationships? Click on the Relationships icon in the toolbar and set them up there. Then when you add tables to a query, it should automatically put the links in there for you.

 

[Corticus]

Since queries are just representative of their source tables, chances are you changed soemething there. Perhaps you changed a tables field name, or deleted a field. Also, if Access doesn't like your query, it will trying to make something that makes sense out of it. keep in mind, your query is really the SQL behind, so keep your eye on this.

 

[Seti]

Turns out that I have an update query that was causing all of the problems. Thanks for the comments as they helped me understand what was happening.