I am wanting to restrict a view based on the client who is looking at the view.

I have 2 tables.

User Table: This contains the User Name, Email and the Client Name
View Table:
This contains all sorts of fields including Client Name

Any suggestion on how I would restrict the view so only records that match the Client Name are shown?

Producing a new view that has a filter for each client is not very workable, as I will have to create a new for every new client.

Glenn.