Relationship deleted but still added when a new query is made

J

Julia

Hi,

I have a couple of relationships that I deleted in the "Relationships"
window (right mouse click then "Delete relationship", yet when I make up a
new query, I see the relationship back again. This stuffs up the joins and as
understanding the SQL statement isn't one of my strong points, I have some
trouble with making up new queries.

Anyone else come across the same problem? Can anyone help?

Julia
 
J

John Spencer MVP

It is possible that Access is making an automatic join based on the field
names in the tables being the same. There is a property that you can set for
the database under Tools: Options on the Tables/Queries tab. Uncheck Enable
AutoJoin.

Helps says
"... automatically create an inner join between two tables... The two table
must have fields with the same name and data type and one of the join fields
must be a primary key."


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

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

Deleted Table Relationship (AND table) still exists... 3
Access says a relationship exists when there are non - help! 1
Implementing a many-to-many relationship 4
Lookup field and Relationships 2
Unable to add new record in query 1
Lookup Table Trouble 2
SQL query with Many-To-Many relationship??? 2
Relationship with a Primary Key? 4

Top