Hey everybody, I created a database that is sorted with a drop-down. I was wondering if there was a way to have a 'select all' in the drop down menu because once someone sorts by a feature, they cannot unsort it.
For example, this database is for actors and once someone sorts by hair color, they have to select a hair color and cannot just go back and unsort by hair color and sort by just eye color instead. I currently have a neutral option where the value is set by a common aspect to all the features, such as a letter they all share, but as I'm adding more options that is getting complicated.
Any ideas would be appreciated! Love this forum!