You wont be doing this on product insert.
you will need to create a whole new page to select the album product then probably have a multiple select list that allows you to select all of the song products that should be associated with the album and insert the ids to the new albumsongs table.
you are going to have to do some custom coding to get this to work, and is not something that we can offer support for.