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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top