multiple records with one form

[qasmi]

I am using asp and ms access. I submit a form where are different field which submit to a ms access table....things are fine and its working but now I need to submit the same form like this :

lets suppose there are 8 total fields and all are text fields except one which is a list box which contains different categories. when a user fill up a form and in the list box selects more than one category then it should submit the records against every category I mean all fields and then the category. if there is one category selected it will add one record row and if there are 4 categories selected it will add 4 record rows. any ideas....
thanks in advance!

Regards,
Qasim

 

[shaddow]

<input name="name">

<select name="val" multiple size=5>
 <option value="v1">V1
 <option value="v2">V2
 <option value="v3">V3
...
</select>

<%
for i=0 to Request.Form("val").Count -1
 name=Request("name")
 val=Request.Form("val")(i)
 'insert data to database
next
%>

________
George, M
Searches(faq333-4906),Carts(faq333-4911)

 

[Anthony1312002]

What does you form look like?