I want to filter all views according to a value in a field called Client in a table called GlobalFilter.

So, I want each view to show only values where Client == GlobalFilter.Client

I'm guessing this won't work because the LHS of that formula is a string and the RHS is an array.

Please advise how to achieve this.

For the record, I am preventing the user from entering duplicate Clients into the GlobalFilter table.

Justin