Listbox Values

[isa.waleed]

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.

[siteguru]

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.