I am new here and trying to create an app that would allow one to filter on multiple criteria. (imagine creating trying to filter a list of all cars to only cars that have 6 cylinder engines, color red, and 40 mpg). I can see how i could sort cars by color, but how could I filter on several tables? (sort by: engine type; color; mpg)
Since I have many criteria to filter on, it is not reasonable for me to create separate views. However if this was my only option, I would like to know if there is a way to have more than 5 views.
If there is anyone out here that would be willing to work with me to get a project done, I would appreciate it.