Thanks John!
Dennis
________________________________
Från: John Viescas <john@viescas.com>
Till: MS_Access_Professionals@yahoogroups.com
Skickat: tisdag, 11 oktober 2011 21:12
Ämne: RE: [MS_AccessPros] Failuire to establish a one-to-many relation between two tables
Dennis-
Access will show the 1 and infinity signs only whey you have defined the
relationship in the Relationships window and have turned on Referential
Integrity.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dennis Davidsson
Sent: Tuesday, October 11, 2011 9:06 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Failuire to establish a one-to-many relation between
two tables
Hello,
I try to create a query using two tables A and B. The primary key of table A
appears in table B as a secondary key. The relation between the two tables is a
one-to-many relation. Nevertheless, when I add the two tables in the query
design mode, the tables are immediately connected by Access using this key, but
the normal "one" and "many" notations do not appear at the resp. ends of the
connection line, as it normally does, when tables are connected like this. Also
the connecting line itself is much thinner than normally, indicating ( I assume)
that there is something wrong with my connection.
What could possibly be the cause? What kind of error should I look for?
The strange thing is that, as far as I can see, the result of the running of the
query looks as I would expect.
Regards
Dennis Davidsson
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Selasa, 11 Oktober 2011
SV: [MS_AccessPros] Failuire to establish a one-to-many relation between two tables
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar