Relations

  • Thread starter Thread starter il barbi
  • Start date Start date
I

il barbi

I noticed that by deleting all relations from my DB all
seems work the same way - I think because the relations are
also repeated in the queries. Just to know...
il barbi
 
That depends, ... when you say "deleting all relations", what does that
mean? How did you do that? It may be that the relationships are still
established, but no longer visible, which could explain why you found them
"repeated in the queries".

Jeff Boyce
<Access MVP>
 
"Jeff Boyce" <[email protected]_HYPHEN_TO_END> ha
scritto nel messaggio
That depends, ... when you say "deleting all relations", what does that
mean? How did you do that?
Click to expand...
I just chose "Tools - Relations" and then deleted all tables
in the window
It may be that the relationships are still
established, but no longer visible, which could explain why you found them
"repeated in the queries".
Click to expand...
When I created the queries, I had already defined the
relations, so in the query structure window the relations
were automatically displayed - Then I deleted the relations
as I said and noticed that all was working as before, this
is my question
il barbi
 
I rather suspected that. If you delete a table from the Relationships
window, the relationship still exists. You can confirm this by going back
to the Relationships window and clicking on the toolbar button for <Show
All>.

That you can see the relationships/joins when you build a query tells you
that the relationships still exist.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top