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. Advertisements

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. =?Utf-8?B?U3lsdmFu?=
    Replies:
    4
    Views:
    5,628
    =?Utf-8?B?U3lsdmFu?=
    Nov 26, 2005
  2. Dennis
    Replies:
    0
    Views:
    4,240
    Dennis
    Jun 26, 2006
  3. sumi
    Replies:
    7
    Views:
    411
    Jorgen Grahn
    Nov 9, 2005
  4. Jimmy

    Library for Filtering User Input?

    Jimmy, Aug 10, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    350
    Jimmy
    Aug 10, 2006
  5. pj
    Replies:
    2
    Views:
    2,120
  6. Guest
    Replies:
    5
    Views:
    567
    Scott David Daniels
    Mar 30, 2007
  7. Homer
    Replies:
    3
    Views:
    8,210
    Alexey Smirnov
    Sep 25, 2007
  8. Tony Johansson
    Replies:
    3
    Views:
    17,135
    Patrice
    Jan 2, 2010
Loading...