Adding multiple records - How?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hey there 

I am getting somewhat lost with my insert code. I have an upload page where the user selects name, address etc then seklects a a manufacturer (ManufacturerID) and then may check 4 dynamic checkboxes (CategoryID) 

I have a main table called products that has 2 foreign keys from tables Manufacturer and Category. 

I have insert code as follows but I am unsure what code goes just below it to loop through and insert the additional records: 

Code: 
<% 
If Request("selected") Then 
ProductsRS.addnew 
ProductsRS("CategoryID")=Request("CategoryID") 
ProductsRS("ManufacturerID")=Request("ManufacturerID") 
ProductsRS("Product")=Request("Product") 
ProductsRS("Description")=Request("Description") 
ProductsRS("Image")=Request("Image") 
ProductsRS("Price")=Request("Price") 
ProductsRS.update 
ProductsRS.requery 
ProductID=ProductsRS("ProductID") 

*** NOT SURE OF CODE HERE**** 

next 
Response.Redirect("Default.asp") 
end if 
%>

Does anyone have any ideas? 

Thank you