Unanswered: Dropdown menu contains multiples of the same person
I'm trying to create a music database of all the albums and tracks from the different albums in my collection.
I'm having trouble trying to figure out the dropdown menu bit. As you know every artist or group has a numerous amount of albums and every album has many tracks. I create a dropdown menu for the artist but when I do, I get a numerous of the same artist. For example, if I have like 5 Queen albums, the name 'Queen' will appear 5 times in the list like theres 5 different groups called 'Quuen'. What I would like to know is how to get the dropdown menu to show just 1 name and upon clicking that name, the form will goto the first record under that name? So its like a query but it still shows the rest of the records.