Linking Drop Down List OnClick to Database Collection URL Link

Hi all,
I’m not a coder or anything so it may be something simple. I’ve spent awhile getting my 3 dropdown lists to finally work, now I need to connect the last dropdown list to certain products on my page through url links. I just want it to go straight to the page when the year is last selected of the menus. How would I go about doing this, not sure if I have anything setup right but here is my collection. Just one link on there but I am trying to test it. Is there a code I am suppose to put in to make the onclick work for the year dropdown list?

Thanks!

Hi,
You need to create an onChange event for each dropdown, if all drop-downs have values , use query to get the relevant data from the collection and redirect the user to the link with wixLocation.to().

Let me know if you need further help.
Or :slight_smile: