Hi all
I’m having a very strange problem with views not dispalying documents correctly…it almost seems as though the view is ‘caching’ the previous user…
The aim is to display to the user only those documents where the user = the name in the field ‘EmpName’ or they are a member of a role…
I would expect this to either, fail and return everything, return nothing or return only docs where there username matches the EmpName field, however, it continually shows the ‘last person’ to access the view, not the one currently accessing it… I’ve put a msgbox on postopen to check the username being rtnd, and this is correct…am baffled…any ideas /suggestions…??
FIELD EmpName:=EmpName;
user:=@Name([CN];@UserName);
SELECT Form = “Employee Form” &
(
@Contains(EmpName;user) |
@IsMember(“[Personnel]”;@UserRoles) | @IsMember(“[Admin]”;@UserRoles) | @IsMember(“[Directors]”;@UserRoles)
)
TIA…!