How to use dropdown button as a filter?

now i can only add a filter on the database1 link on the page, but do i need to create a individual table and database2 link to show the contents that are note filtered by database 1 link? ,

is there any way to show everything on the single table using some buttons or drop-down menus?

You can connect any dropdown to a collection, you can code when dropdown value changes and then populate table with data from another collection if the fields are dynamic I guess. If not working you can put several tables on each other and use show hide depending on which data you want to show.

Please sent some examples code for connecting drop down values to the table That dynamically change when values changed,

I have tried hiding options, but I have too many tables it’s lot of work,

Just search forum for dropdown, lots of discussions on that