using dropdown box to display db record & update record

Discussion in 'ASP General' started by Jimmy Tran, Oct 3, 2003.

  1. Jimmy Tran

    Jimmy Tran Guest

    Hi Folks,

    I have a web database written in asp and using access97. I have many
    projects, but each project is being held responsible by a person. All
    people and projects come from the database. Looks like this:

    Responsible Person Project Name

    Canter, Joe Project A
    Williams, Bob Project B
    Fowler, James Project C
    Canter, Joe Project D

    I can have these database displayed in a table using asp and it works
    fine. What I really want to do is where you see the Responsible names
    above which corresponds to a particular project, I want those names to
    appear in a drop down box. The drop down box will still have the
    Responsible names above displayed but at the same time pull all of the
    other Responsible names in the database as a selection--this way a user
    can view the above table and re-assign people to different project as
    they want. After doing so, they can click submit and the database
    containg Responsible Person and Project Name is updated. I have been
    trying different ways but nothing seems to work. If you could give me
    any help or advice, I GREATLY appreciate it.

    Thank you in advance
    Jim

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
     
    Jimmy Tran, Oct 3, 2003
    #1
    1. Advertising

  2. Jimmy Tran

    Dan Brussee Guest

    On Fri, 03 Oct 2003 07:44:44 -0700, Jimmy Tran <>
    wrote:

    >Hi Folks,
    >
    >I have a web database written in asp and using access97. I have many
    >projects, but each project is being held responsible by a person. All
    >people and projects come from the database. Looks like this:
    >
    >Responsible Person Project Name
    >
    >Canter, Joe Project A
    >Williams, Bob Project B
    >Fowler, James Project C
    >Canter, Joe Project D
    >
    >I can have these database displayed in a table using asp and it works
    >fine. What I really want to do is where you see the Responsible names
    >above which corresponds to a particular project, I want those names to
    >appear in a drop down box. The drop down box will still have the
    >Responsible names above displayed but at the same time pull all of the
    >other Responsible names in the database as a selection--this way a user
    >can view the above table and re-assign people to different project as
    >they want. After doing so, they can click submit and the database
    >containg Responsible Person and Project Name is updated. I have been
    >trying different ways but nothing seems to work. If you could give me
    >any help or advice, I GREATLY appreciate it.
    >


    When you say it doesnt work, what do you mean? Does it not fill the
    list? Does it not update correctly?
     
    Dan Brussee, Oct 3, 2003
    #2
    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. Replies:
    1
    Views:
    2,479
    OHM \( One Handed Man \)
    Apr 2, 2006
  2. Mike
    Replies:
    1
    Views:
    812
  3. Gnarlodious
    Replies:
    4
    Views:
    17,610
    elizas
    May 5, 2010
  4. Replies:
    1
    Views:
    863
    Jonathan N. Little
    Jan 10, 2007
  5. J MCallister

    using dropdown / dynamic display change

    J MCallister, Jun 8, 2007, in forum: Javascript
    Replies:
    4
    Views:
    105
    Geoffrey Summerhayes
    Jun 9, 2007
Loading...

Share This Page