Is there a way to cusomtise the Advanced search feature in the database module to create dropdown menus which can be automatically populated with options from the database?
All information in the database is uploaded from csv and I would like the search function to produce a dropdown list of locations which appear in a certain field.
I have tried usoing the menu option but this needs the options to be predefined prior to uploading. I envisage something like the autofilter function in Excel.
I'm fairly new to programming, so if anybody could talk me through this or give me a broken down example of this I would be most appreciative.