I am not a computer guru but I would like to understand why Access
can’t handle a many-to-many relationship in a table.
Would your queries still work (i.e. giving you the right results) if a
third table is not used on a many-to-many relationship table?
Many-to-many relationship is quite common in real life. E.g.: a child
can have one or more parents and a parent can have one or more child.
In your explanation, I would appreciate if you could use real life
examples to demonstrate the issues and problems that you would
encounter if you do not use a third joining table.
Make your own search :
Copyright © 2001-2012 GNT Media