I want to find out the best way to accomplish this. I
have a form that inserts documents for the user. There
can be many documents for 1 user. Currently, there is a
form that list user information and all the documents a
user can choose via checkbox. I am using ASP to loop
through the value of the form variable, then the next page
perform the inserts based on the number of checkboxes
entered on the form (Documents are read from db and
identified by checkboxes on the form). I want to populate
the tblUserDocuments from the userid and all the document
ids that the user has chosen. I'm using ASP/SQL Server.
Is there a simpler way instead of making an array, then
looping through the array? Could I use the IN clause for
an sql Statement? Here is my table structure:

tblDocuments
documentID int primarykey
documentTitle varchar(50)
documentDescription varchar(500)

tblUsers
UserID int primarykey
UserFName varchar(50)
userLName varchar(50)

tblUserDocuments
UserID int
DocumentID int

Thanks