Selasa, 11 Oktober 2011

[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]

__._,_.___
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