Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    New York
    Posts
    47

    Unanswered: filtering for one users records

    I have a database with confidential info for kids. the coordinators need to see the records of their kids but can not see the kids of the other coordinators. How can I create a log in that only allows the coordinator to see the kids that are assigned to them.

    Thanks
    Terri
    Terri Gavin

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Add a field to the table which is called something like LoginIDofAssignedKids (text). Then utilize the getuser() routine (found in the codebank) which get's the current user using the mdb. You can filter records based on the current user.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •