Ok, I think I am going mad over this one. I am trying to create a view where the current DB user sees all the documents where their username is listed in a specified field within those documents. This is my view selection:
Selecttitle_10 is a name field.
Now, it seems to work, but, when I switch user IDs and select that view again, it displays the previous user IDs documents ather than the current user ID's documents. I have to go into design, refresh the view using the curly thing at the top left, close and save it and then the view is updated with the new user IDs documents. This is a bit frustrating, it's as if the view is not refreshing when the DB is accessed by a new user.
Anyone got any idea's of what I am doing wrong or am I just expecting too much?