Selasa, 11 Oktober 2011

SV: [MS_AccessPros] Failuire to establish a one-to-many relation between two tables

 

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]

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar