Set relationships or queries?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
It depends what you want..I think I have the same problem as you
 
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
 
Back
Top