Starting with Access. In query screen, when one drags a relationship, on one end of the line there is (typically) a 1 while on the other side there is the infinity sign.
Suddenly, the line is still there and the type is still 1 (1 to infinity) but the two little icons are gone. There are more people here who have that...
How do I get these back?
Relationship icons query disappear
-
- BronzeLounger
- Posts: 1253
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1253
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Relationship icons query disappear
2010 (it also happens in 2007)
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Relationship icons query disappear
I've never seen that happen spontaneously in either Access 2007 or Access 2010 (I've been using the latter for two-and-a-half years now).
The 1 and infinity symbol are displayed if there is a one-to-many relationship between the tables (in the Relationships window) for which Referential Integrity has been enforced.
If Referential Integrity hasn't been enforced, or if no relationship between the tables has been defined, the join in the query will be displayed as a thin line without 1 and infinity symbol.
The 1 and infinity symbol are displayed if there is a one-to-many relationship between the tables (in the Relationships window) for which Referential Integrity has been enforced.
If Referential Integrity hasn't been enforced, or if no relationship between the tables has been defined, the join in the query will be displayed as a thin line without 1 and infinity symbol.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1253
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Relationship icons query disappear
Relationship shows 1-many (with symbols) and Integrity enforced in enabled. When I switch to a query, there is still a line showing the relationship but there the 1-many icons are gone...
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Relationship icons query disappear
Sorry, I can't explain that. Even if I delete a join in a query and create a new one by dragging a field from one table to another, the join line will miss the symbols, but once I save, close and reopen the query, the symbols are back.
Best wishes,
Hans
Hans