Vanishing Links Between Tables

  • Thread starter Thread starter Serge
  • Start date Start date
S

Serge

I created several queries with several linked tables.
For some reason one of the links between the tables
vanishes after I save the query (the funky thing is that
it doesn't vanish immediately after I save the query;
sometimes it vanishes after the 2nd or 3rd time I open
the query). Any ideas what might be causing this?
 
I created several queries with several linked tables.
For some reason one of the links between the tables
vanishes after I save the query (the funky thing is that
it doesn't vanish immediately after I save the query;
sometimes it vanishes after the 2nd or 3rd time I open
the query). Any ideas what might be causing this?
Click to expand...

What "vanishes"? Are you looking at the table Relationships window,
the query grid, the SQL of the query? It sounds like it might be just
a display bug - take a look at the JOIN clause in the SQL view of the
query to be sure.
 
Back
Top