G
Guest
I have a songlist database with over 100,000 songs listed by artist, title,
disk# and track#. There are many duplicate songs by many labels with the
same artist and title. I'm trying to create a songbook with out duplicate
songs by the same artists. I want to be able to list all the songs by all
the different artists with out having duplicates. To further explain, if I
assign the title field as the key, I will get all titles but only by one
Artist not by all of them. Its like I need two key fields with unique
values. I've been trying different filters and querys but just can't figure
out the proper procedure. Please help.
disk# and track#. There are many duplicate songs by many labels with the
same artist and title. I'm trying to create a songbook with out duplicate
songs by the same artists. I want to be able to list all the songs by all
the different artists with out having duplicates. To further explain, if I
assign the title field as the key, I will get all titles but only by one
Artist not by all of them. Its like I need two key fields with unique
values. I've been trying different filters and querys but just can't figure
out the proper procedure. Please help.