Use a parameterized named query, and use the first dropdown's value as the parameter to the second dropdown's query. That's it.
