ok not sure exactly what you mean. At this time lets say I have 2 tables artist and song where
Artist table has
song table has
How would the relationship you spoke about work in this case as the artist.artist_id is already one to many with song.artist_id.