Create a search form
Hi, I am trying to create this musician database and search form, which allows me to choose the Year and Musician Name from 2 drop down menus and returns results of the albums that the musician has released. I think I need a script to do this but I have no idea how to.
I started by creating a new layout with 2 drop down menus - Year and Musician Name. After selecting and click on a "Go" button, I want results to be returned in a new window. If there is no result, I would like to have a pop-up window that says "No album released by musician in this year".