Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Query based on workgroup user

    We have a database with multiple salesmen and quotes.

    Right now, they can bring up quote reports via a combo box that lists all of the salesmen right our of the salesman table. When they select a salesman, it loads the reports for that salesman.

    The problem is that we want to be able to only allow a salesman to see his quotes, but allow the managers to see all quotes.

    I can feed the report combo box via a query instead. Is there a way to capture the workgroup login name and use it to automatically modify a query to only show the salesmen that user is supposed to see?

    Thanks, and I only have sample data in the dB right now, so I'd be more than willing to sed it if someone want's to take a look @ what we've done.


  2. #2
    Join Date
    Sep 2003
    Have you tried CurrentUser()? THe only drawback is that if the System.mdw is used then all users will appear as "Admin" ...

Posting Permissions

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