Help with Many to Many relationship

[grubster]

HI, I'm trying to make a many to many relationship in access 2000 and am having difficulties.I want to link my orders table to my Equipment table, so an order can have many equipment, and equipment can be in many orders. Order has: (O#,C#,S#,ModelNumber)with O# as primary Key
Equipment hasModelNumber,Model,brand) with ModelNumber as primary key
I made a Order Info table with(QTY,ModelNumber, and O#) with ModelNumber and O# as foreign Keys.

Then I linked the Equipment to Order Info table via modelnumber and linked order to Order Info table via O#.
It will only give me a 1:1 relationship into the contains table. I need a one to many between each to create a many to many, I'm really stuck here, any help would be great, because based on everything I know, I'm doing this how you are supposed to. thanks.

 

[JUANCARLOS]

The solution is create a table names: details of Order in this table have the following fields:

Id Code autonumber
#O Code of Order, and
#E Code if equipment
teh relationships (one #O table orders, to many #O table details of order)
and (one #E table equipments to many #E in the table details of order) under this structure you can mantain a many to many relationship.

In the forms, you must to create a subform based in the table details of orders, the asistent, can help you to create the structure you need.