too many one-to-manys! help!

[Guest]

I'm constructing a database for a journal. I need a table containing the
articles (or at least the titles of the articles) published issue by issue
over the years. I also need a table of the accumulating list of contributors.
Some articles have multiple authors, and some authors contribute more than
once. I need to be able to retrieve data on which articles were published in
each issue, and who the multiple authors were, and from the opposite
direction I must also be able to view what articles (sometime multiple
articles) each author has contributed to.

I'm finding it very tricky to juggle the complicated many-to-one and
one-to-many relationships here. Some sort of junction table seems called for
but I haven't so far been very successful getting these to work.

I'm sure there must be a well established way to approach this jumble and
I'm hoping someone can give me some tips.

 

[Douglas J. Steele]

Since you've got a many-to-many between Articles and Authors, yes, you need
an intersection table to resolve that many to many.

This is similar to the relationship between Products and Orders in the
Northwinds database that comes with Access. There, it's resolved by the
Order Detail table.

The easiest way to maintain the information is with a form containing a
subform, like the Orders and Orders Subform in that database.