relationship lines

  • Thread starter Thread starter John T Ingato
  • Start date Start date
J

John T Ingato

Probably a stupid question:

when I add tables to my queries, they are joined by lines. Usually they are
just straight line. If I do an outer join, one end of the line has an
arrow. so far so good, I understand all that.

I am reading MS Access 2003 Inside Out, and many times in the illustrations
of the queries tables, the lines have a 1 on one end and an infinity symbol
on the other end. should I be seeing this in my queries? Is there
something I am missing?
 
John T Ingato said:
Probably a stupid question:

when I add tables to my queries, they are joined by lines. Usually
they are
just straight line. If I do an outer join, one end of the line has
an
arrow. so far so good, I understand all that.

I am reading MS Access 2003 Inside Out, and many times in the
illustrations
of the queries tables, the lines have a 1 on one end and an infinity
symbol
on the other end. should I be seeing this in my queries? Is there
something I am missing?
Click to expand...

When you set relationship in the relationship window, and chose to
enforce referential integrity (usually recommended), this is visually
observable both in the relationship window, and in query grid when
those tables are added to the query grid as the symbols you describe.

I don't know the book you are referring to, but does it have a chapter
or two with some of these topics; data modelling, normalization,
relationship or similar, then perhaps have a look through it/those,
and check out if you're missing something ;-)
 
Back
Top