I lost the join in a few queries...how can this happen?

[colezpapa3]

Every Wednesday, I run a series of queries which are exported into Excel sheets. Today, after being notified by the user that the reports were wrong...when I examined the queries, I noticed I lost my joins. There were 3 queries where I lost the join. What can cause this and how can it be prevented.

 

[MakeItSo]

My first - and second - thought is: manual interaction.
I do not know of anything that causes the loss of joins in existing queries other than manually removing it or renaming one of the joined fields.

[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell

 

[genomon]

If someone renamed source tables, the joins will be lost.

All I ask is a chance to prove that money can't make me happy.

 

[colezpapa3]

OK thanks. I think that is what happened.