Thanks, Ajax;
I seem to have been approaching this from the wrong angle;
I had always thought the hierarchy should be Artists > Albums > Songs, and when I tried a many to many join table, I only joined artists and albums, but not songs.
I will certainly take your advice and go with all three tables being joined by tbl_AlbumArtistSongs.