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]
Selasa, 11 Oktober 2011
[MS_AccessPros] Failuire to establish a one-to-many relation between two tables
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar