filtering data by login user

Discussion in 'ASP .Net Web Services' started by Gordon, Oct 15, 2008.

  1. Gordon

    Gordon Guest

    I have a simple access database, which has 3 tables:
    User(UserID, UserPwd, UserCustID, etc),
    Customer(CustID, CustName, etc)
    Invoice(InvID, InvCustID, etc)

    There may be more than 1 user, and more than 1 invoice for each customer.

    I plan to post the data on a website to allow the customers to view their own
    invoices:
    1. I will create at least 1 user for each customer to log on the web site.
    2. When a user logs on, the system will retieve its UserCustID, then pass this
    retieved UserCustID to the next ListInvoice page
    3. In the ListInvoice page, make InvCustID=UserCustID to filter the records.

    Your suggestions and/or codes will be greatly appreciated.

    gordon
     
    Gordon, Oct 15, 2008
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. William F. Robertson, Jr.
    Replies:
    0
    Views:
    443
    William F. Robertson, Jr.
    Jul 2, 2003
  2. sumi
    Replies:
    7
    Views:
    298
    Jorgen Grahn
    Nov 9, 2005
  3. pj
    Replies:
    2
    Views:
    1,943
  4. Guest
    Replies:
    5
    Views:
    428
    Scott David Daniels
    Mar 30, 2007
  5. Tony Johansson
    Replies:
    3
    Views:
    16,250
    Patrice
    Jan 2, 2010
Loading...

Share This Page