Restrict data that users view in multiuser environment

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • thadi
    New Member
    • Oct 2006
    • 1

    Restrict data that users view in multiuser environment

    I have a Timekeeping Database that will be used by the Time Keepers
    in various departments. I want to restrict view of the data of one
    department from the other department. I created seperate query for
    each department. I have idea about the workgroup and currentuser
    function. But I don't know where to apply currentuser function.
    How would I go about doing that. Any help or example given is
    apprecited very much.
  • PEB
    Recognized Expert Top Contributor
    • Aug 2006
    • 1418

    #2
    Hi,

    To check your user

    Res:IIF(Current user()="1", True, False)

    as criteria under this column you type True

    And the result is that those records are shown for user "1"

    :)

    Comment

    Working...