SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Listbox Values

  1. #1
    SitePoint Member
    Join Date
    Apr 2013
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Listbox Values

    Dear All,

    ASP Classic: I have a form that used for inserting a training record details into a tbl (trainingrecords). Within the form i have a listbox (ProgramName) that gets its values from a tbl (TrainingPrograms).

    For example:

    Programs:
    - 1 Finance
    - 2 IT

    If the user chose the item no from the listbox and click add, i need to save two values Id, and program name to the tbl (trainingrecords)
    ID (Autonumber) ProgramID Name
    1 2 IT

    Could you please help me in this issue.

    Best regards.

  2. #2
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,608
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    I would NOT do that. I would have a table that cross referred the User to the Training.

    Table: TrainingPrograms
    TrainID | ProgramName

    Table: Users
    UserID | UserName | FirstName etc.

    Table:UserTraining
    TrainID | UserID

    Create the form checkboxes based on the TrainingProgams table. Take the submitted form (I presume you have some means of knowing WHO has completed the form?) and update the UserTraining table with the results - separate entries for EACH selected program per user.
    Ian Anderson
    www.siteguru.co.uk


Bookmarks

Posting Permissions

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