Set relationships or queries?

[Guest]

I have made 3 tables: (1) IDTract (autonumber); (2) IDDocument (autonumber);
(3) IDOwner(autonumber). These are all many-to-many relationships. Can this
be? I need to know how to set this up. When I try to make the relationship,
I only get one-to-one. I have not made any queries yet. I thought I had to
join the relatonships first.

The form I've created uses all fields from the tables except the autonumber
fields.

 

[donovan magnefico via AccessMonster.com]

It depends what you want..I think I have the same problem as you

 

[Guest]

A many to many relationship is only possible by using a third 'joining'
table. For example if you have an orders table and a product table where each
order can contain multiple products and each product can be on multiple
orders, you need a ProductOrder table. A single relationship link can only be
one-to-one or one-to-many. An example:
Orders table
1
2
3

Products table
A
B

ProductOrder table
1 A
1 B
2 A
3 B