Sikh Philosophy Network - View Single Post - Many-to-many relationship

#1 (**permalink**) 11-Nov-2005, 20:09 PM

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# and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7162-many-to-many-relationship.html
Reference:: 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?
--
Ronnie