Many "One to Many relationships"

[Marc Noon]

two or more one to many relationships.

Is it possible to have two or more "one to many" relationships of my table.


Thanks,
Marc

 

[Jeff Boyce]

Marc

You didn't mention whether your table has multiple one-to-many relationships
with others, or if other tables (multiple) have one-to-many relationship
with your table. Either is possible and common.

What you cannot do is establish a many-to-many relationship -- for this,
you'll need a "junction" (or "relationship" or "resolver", or ...) table.
It will have a one-to-many relationship to each one of the tables that had
the original many-to-many.

If this hasn't answered your question, please post back a description of the
specific tables you are considering.

 

[John Vinson]

two or more one to many relationships.

Is it possible to have two or more "one to many" relationships of my table.

You can have up to thirty-two.