Relationship trouble - jaja

[vastago]

Here's my problem, I've been at it for weeks but still no solution.

I have 2 tables, one for songs and one for songwriters. One song can have many songwriters and one songwriter maight have many songs (many to many relationship, right). How do I make this work, do i need a join table? and what would that be? I'd like to be able to report by songs:

song1 has:

writer 1

writer 2

song2 has:

writer 1

writer 3

and also report the following:

writer 1 has:

song 1

song2

writer 2 has:

song 2

song 3

Any help is good.

Thanks a million.

[Wim Decorte]

Yes you need a join table. See screenshot.

See also attached file. You'll see that on the writers layout I've put a portal to the join table. But the name of the song is a field from the songs table which is related to writers through the join table. The join table itself just stores the combination of writerID and songID.

Same thing on the songs layout: a portal to the join table and the name of the writer is a field from the related writer table.

forums_songs.zip