what is an Intermediate table? Many-to-Many problem.

[Nathon Jones]

Hi,

I'm having real problems with something that, I think, should be quite
straightforward.
I know I'm missing something in my way of thinking here...

I've got Artists and Events tables in my Access DB.

More than one artist might appear at any event and vice-versa.

I was informed that this is a "many-to-many" relationship and that I would
need to create an "Intermediate" table with:

ArtistEventID
ArtistID
EventID

....if I wanted to create a situation whereby I could highlight more than one
artist for any event, and more than one event for any artist.

Yup....I'm completely confused. Can anyone help?
Nath.

 

[Mark]

There's a good example and explanation at:
http://www.microsoft-accesssolutions.co.uk/many_to_many_example.htm

 

[Sprinks]

Nathon,

See my post on your original thread. Most basically, "intermediate" or
"junction" tables model a many-to-many relationship by creating two
one-to-many relationships--in this case, one artist will have many
ArtistEvent records, and one event will have many ArtistEvent records.

Sprinks