I am building a database of thousands of records called products.
I am looking for a way to filter this more effectively. We have one filter already - a main filter called categories (about 10 in number). We have another filter called applications (almost 100 of them). I want to use filter the applications depending on the category chosen. So basically a multi-step filtering or conditional filtering.
The end product will look like this… category filters application, then application filters products.
Will appreciate any ideas on how to do this including using custom code? I will really appreciate.