- Local time
- Today, 04:18
- Jul 24, 2020
Don't worry @MickJav I'm thinking of doing it exactly as you say.A Duet I think Is what I refer to as a Combination which I have tried to show you in other topics as well as this one
Christina Aguilera Feat. Lil' Kim
Is Made up of
I always Add both as in Christina Aguilera Feat. Lil' Kim As it's easy for me to find all tracks By Christina Aguilera which would include the feat. tracks
To add another many to many table between tblTrackNames And tblArtists would in my view be unnecessary and would cause a lot of additional work with the design which I really don't think you would be able to manage.
Sorry to say but I wouldn't help if the continued to insist you needed to take that course.
However, in my list of tracks (tbl_music, (must change that )) I have a lot of tracks that I don't have in my vinyl record collection. These tracks, songs or whatever you want to call them is from my radio programs. Sometimes I have to choose songs that I don't own.
Those also needs to be related to the artist table. Because I also want to have my programs in the db, as you so nicely presented for me.
As it is now the track needs to have a relation to a record to be connected to a artist.
If I, as @Pat Hartman says, don't use the artist_ID in the music table I loose the relation with the artist. I could then create a m-m table, but as you say, it might create a lot of unnecessary problems for me.
This is what I've been doing today.