Thin join line in query after establishing RI in Relationship Wind

[AccessNovice07]

I have established RI between the tables in my database; I can see the thick
join lines and the "1" and "infinity" symbol in the relationships window.
However, when I start a select query and add tables the tables are linked
with the thin join lines. Why are they not connected with the RI (thicker)
lines? The tables in the select query window were previously connected with
the thicker RI lines; but aren't now. Why?
THANKS! I am using Access 2007.

 

[Roger Carlson]

Hi,

I answered this in another forum, but I have to admit <egg on my face> that
I was wrong. It's a behavior I've never noticed with Access.

When you add tables to a query, the join that is automatically formed based
on the established relationship does have a 1 and the "infinity" symbol. If
you delete that join and create one of your own, it will not. I can't find
any way to make it look like a relationship except to delete one of the
tables and re-add it, allowing the auto-join to create the join.

Very odd behavior. If anybody else can explain why this is, I'd like to
hear it.

Still, it doesn't effect the join in any way, so I don't think you need to
be concerned about it.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[KARL DEWEY]

Maybe I am missing what you are seeing but the line is thicker when it has
focus.
If you click somewhere else it will get smaller. This happens in the
Relationship Window and query design window.

 

[Roger Carlson]

No. The OP is pointing out that when you add table to a query and it
auto-joins them based on the relationship, the ends of the line are thicker
and there is a "1" and "infinity" symbol on the join line, just like in the
Relationships Window. However, when you create the same join yourself, it
doesn't. I guess I had never really noticed this behavior before. It
doesn't alter the way that the query or relationship behave, which is what I
was trying to convey.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L