I am trying to create a many-to-many relationship. I have 4 tables set
up--#1 has a customer id #; #2 has item id#; #3 has purchase order id# andReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7162-many-to-many-relationship.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7162
customer id; #4 has purchase order details with purchase order id and item
id. The PO Details table contains 2 key fields from 2 of the other tables.
I am only able to set up a one-to-one relationship--I cannot get create a
many-to-many relationship. What am I doing wrong?