Create 'course' database query in asp

I'd like to offer a 'course type' database query in asp similar to the attached 'weather' query. The filters on the top row would be the same - 'Year', Month' and 'Tour' and the filters in the bottom two rows would also be the same - 'First name' and 'Surname'. Instead of the three filters in the 2nd/3rd rows, the following would be filters for this 'course type' query: 'Par' - drop-down list - the relevant field for this filter is 'Par' in the 'Events' table in the [login to view URL] file. 'Yardage' - drop-down list - the relevant field for this filter is 'Yardage' in the 'Events' table in the [login to view URL] file. 'Architect' - drop-down list - the relevant fields for this filter are the 'Architect1', 'Architect2', 'Architect3', 'Architect4', and 'Architect5' fields in the 'Course' table ([login to view URL] file). There can be as many as five different architects for each course, so the query will need to run on the text entered by the user to see if it matches the Architect in any of those five fields. 'Greens' - drop-down list - as with the Architect query, there are different grasses that can be used on each green so the query will need to run on the user's selection(s) to see if it matches any of the 'Greens1', 'Greens2', 'Greens3', 'Greens4' fields in the 'Course' table. 'Green Speed' - drop-down list - the relevant field in the [login to view URL] file is 'Stimpmeter' in the 'Course' table. 'Green Size' - drop-down list - the relevant field in the [login to view URL] file is 'GreenSize' in the 'Course' table. I will gladly answer any questions about this project. Thanks for looking. Tony