Results 1 to 3 of 3
  1. #1
    whisp0214 is offline Advanced Beginner
    Windows XP Access 2016
    Join Date
    May 2017
    Posts
    30

    Limiting What Users Can See


    I have a table with Purchase Orders listed. Each order has a Salesperson and Assistant listed along with the order. Each Salesperson and Assistant can only see the orders in the table that have their name attached to it. I log their username when they log in with tempvars and call that back as a criteria in the query. Now there is a new twist. Certain orders will now have multiple assistants. I could add another column for the additional assistant and continue using tempvars to accomplish this, but that seems like sloppy design. Anyone have any ideas that would allow someone to view certain orders when their name is not attached directly to the order?

  2. #2
    BDibz is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2018
    Posts
    62
    Could do a many-to-many relationship with an intermediate table that lists assistants and the orders they have access to?

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 02-15-2018, 03:11 AM
  2. Limiting rights to different users
    By bharatmvs in forum Access
    Replies: 2
    Last Post: 03-22-2015, 08:54 AM
  3. Replies: 5
    Last Post: 12-17-2014, 10:31 AM
  4. limiting checkboxes
    By Sjohnson304 in forum Programming
    Replies: 5
    Last Post: 05-04-2013, 10:53 AM
  5. Limiting access to certain users only
    By huskies in forum Security
    Replies: 1
    Last Post: 04-01-2009, 08:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums