Set relationships or queries?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elizabeth - 28 Apr 2005 17:02 GMT

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.

Signature

Elizabeth

Reply to this Message

donovan magnefico - 28 Apr 2005 17:47 GMT

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

Reply to this Message

mscertified - 28 Apr 2005 18:26 GMT

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

> I have made 3 tables: (1) IDTract (autonumber); (2) IDDocument (autonumber);
> (3) IDOwner(autonumber). These are all many-to-many relationships. Can this
[quoted text clipped - 4 lines]
> The form I've created uses all fields from the tables except the autonumber
> fields.

Reply to this Message