Filter by select

Hi all!

I seem to have some issues filtering a table using a select. I have my table set-up, which has an inner-join to a category column. I have a text input filter set-up to filter the name and reference column and this is working fine.

The select is set up to pull the name and value from the joined ‘category’ table (again working fine) and I have set up the query in the server connect (for the table) as select1.value. Nothing seems to be changing when I select one of the categories.

Any ideas where I could be going wrong here?

Thanks