locked
Filter on Customer Number RRS feed

  • Question

  • I have worked through tutorials on filtering by username but my situation is a little different.  I have an invoices table that I want my customers to be able to view, but only their invoices naturally.  It would not be hard to just add the username to the invoice table, but my customers may have 7 or 8 different users accessing the application.  If I created a table of usernames and their customer number, how would I lookup and pass that customer number into the query to limit the invoices seen by the user.
    • Edited by caw78 Thursday, August 29, 2013 8:24 PM
    Thursday, August 29, 2013 8:23 PM

Answers

All replies