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

    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.

    Terri Gavin

  2. #2
    Join Date
    Dec 2004
    Madison, WI
    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