Viewing documents where the current user equals the user name in a specified field
Posted on 2003-03-30
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?