I have 2 database, one is for workflow and one is for attendance. In the attendance database, I have a view that is called My Time, a simple nice little view that will allow associates to see only their time that they have taken off. The formula for the view selection is:
SELECT employeeName=@Name([CN];@UserName) & Form_Name="Time Off" & Status="Approved" & All_Archive="Active"
Now in my second database, I would like to create the same type of view that is My Calls (since the 2nd is a call record database).
I have copied the same formula over and tweaked it to this:
SELECT employeeName=@Name([CN];@UserName) & Form_Name="Call" & Final_Archive="Active"
This does NOT work, what happens is that all the associate can see my actual calls I have logged and not theirs. But if I refresh the documents they all just go away. I do not understand how this can work in one database and not the other. I did not want to make these private views, so they are currently both shared. If anyone has any suggestions that would be fantastic!