Hi everyone, I really hope someone in here can help me and I will be so grateful as I have spent too many days trying to get this sorted!
So, I am setting up a database with one search bar where you can search by player name (I have sorted this already and it works) and then I have 7 dropdowns that can be filtered.
I have started to write the code for each dropdown and it has been working fine, but, I have now realised that only one dropdown will work at a time. However, I want the dropdowns to work together so that the results shown are the results when multiple dropdown selections are selected.
I am very new to code but is it possible someone could explain the best way to use code so I can filter by multiple dropdowns at the same time? All of my dropdowns only require text.
Thank you for anyone who is able to help!