1-1 relationship
Hi Phippsy
If you double-click on a relationship line in the relationships window, the
Edit Relationships window will pop up. On the left is the "Table/Query" and
on the right is the "Related Table/Query". The "primary table" is the one
on the left.
There is no such thing as a many-to-many relationship. These must be
implemented artificially using a "junction table", which contains foreign
keys for both the tables you want to relate. You then set up a two
one-to-many relationships, between each of the primary tables and the
junction table.
--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand
"Phippsy" wrote in message
...
Hi
I know that 1-1 relationships are uncommon but when you have them how do
you
know which is the primary table. Also if you have a 1-many relationship I
presume that the primary table is the '1'. What about a many-many - could
either be the primary table and how do you know which it is?
Thanks
|