I am building a table based upon products listed in a SQL database. I show the list of products by Group, the user then has the option to add a qty amount to order. My problem is that: when I go to save the ordered products to the database, I use the For Each Item in Request.Form See code below:<BR>&#060;%@ Language="VBScript" %&#062;<BR>&#060;!-- #INCLUDE FILE="DataStore.inc" --&#062;<BR>&#060;%<BR><BR>&#039Declare all local variables<BR><BR>Dim AddConn<BR>Dim AddRst<BR>Dim strCourier<BR>Dim HoldQty<BR>Dim QtyHold<BR>Dim MySql<BR>strCourier = "Purolator Courier"<BR>MySql = "item_master_data"<BR>&#039Set connection object <BR> Set AddConn = server.createobject("adodb.connection")<BR> Addconn.open strConn<BR> Set AddRst = Server.CreateObject("ADODB.Recordset")<BR> AddRst.Open MySql,AddConn,2,2<BR>For Each Item In Request.Form<BR> HoldQty = Request.Form("txtQty")<BR> if isnumeric(HoldQty) then <BR> QtyHold = HoldQty<BR> else<BR> QtyHold = 0<BR> end if<BR> If QtyHold &#062;= 0 Then<BR> AddRst.AddNew<BR> If Not Isnull(Request.Form("txtTerritoryManager")) Then<BR> AddRst("item_terr_man") = Request.Form("txtTerritoryManager")<BR> End if<BR> If Not Isnull(Request.Form("txtaddress")) Then<BR> AddRst("item_ship_addr1") = Request.Form("txtaddress")<BR> End if<BR> If Not Isnull(Request.Form("txtaddress2")) Then<BR> AddRst("item_ship_addr2") = Request.Form("txtaddress2") <BR> End if<BR> If Not Isnull(Request.Form("txtcity")) Then<BR> AddRst("item_city") = Request.Form("txtcity")<BR> End if<BR> If Not Isnull(Request.Form("txtprov")) Then<BR> AddRst("item_prov_etc") = Request.Form("txtprov")<BR> End if<BR> If Not Isnull(Request.Form("txtdate")) Then<BR> AddRst("item_date") = Request.Form("txtdate")<BR> End if <BR> If Not Isnull(Request.Form("txtshipdate")) Then<BR> AddRst("item_ship_date") = Request.Form("txtshipdate")<BR> End if <BR> If Not Isnull(Request.Form("txtphone")) Then<BR> AddRst("item_telephone") = Request.Form("txtphone") <BR> End if<BR> If Not Isnull(Request.Form("txtdaterqd")) Then<BR> AddRst("item_date_reqd") = Request.Form("txtdatereqd")<BR> End if<BR> If Not Isnull(Request.Form("txtcode")) Then<BR> AddRst("item_code") = Request.Form("txtcode")<BR> End if<BR> If Not Isnull(Request.Form("txtdesc")) Then<BR> AddRst("item_desc") = Request.Form("txtdesc")<BR> End if<BR> If Isnumeric(Request.Form("txtqtyreqd")) Then<BR> AddRst("item_qty_reqd") = clng(Request.Form("txtqtyreqd"))<BR> Else<BR> AddRst("item_qty_reqd") = 0<BR> End if<BR> If Isnumeric(Request.Form("txtqtyshipped")) Then<BR> AddRst("item_qty_shipped") = Clng(Request.Form("txtqtyshipped"))<BR> Else<BR> AddRst("item_qty_shipped") =0<BR> End if<BR> If Isnumeric(Request.Form("txtboqty")) Then<BR> AddRst("item_bo_qty") = clng(Request.Form("txtboqty"))<BR> Else<BR> AddRst("item_bo_qty") = 0 <BR> End if <BR> If Not Isnull(Request.Form("txtbodate")) Then<BR> AddRst("item_bo_date") = Request.Form("txtbodate")<BR> End if<BR> If Not Isnull(Request.Form("ID")) Then<BR> AddRst("item_user_id") = Request.Form("ID")<BR> End if<BR> AddRst("item_user_date") = Date()<BR> If Not Isnull(Request.Form("txtgroupname")) Then<BR> AddRst("item_group_name") = Request.Form("txtGroupName")<BR> End if <BR> If Not Isnull(Request.Form("txtCourier")) = True or Not Request.Form("txtCourier") = "" Then<BR> AddRst("item_ship_courier") = Request.Form("txtCourier")<BR> Else<BR> AddRst("item_ship_courier") = strCourier<BR> End IF<BR> AddRst.Update<BR> End If<BR>If err.number &#062;0 then<BR> response.write "VBScript Errors Occured:" & "&#060;P&#062;"<BR> response.write "Error Number=" & err.number & "&#060;P&#062;"<BR> response.write "Error Descr.=" & err.description & "&#060;P&#062;"<BR> response.write "Help Context=" & err.helpcontext & "&#060;P&#062;" <BR> response.write "Help Path=" & err.helppath & "&#060;P&#062;"<BR> response.write "Native Error=" & err.nativeerror & "&#060;P&#062;"<BR> response.write "Source=" & err.source & "&#060;P&#062;"<BR> response.write "SQLState=" & err.sqlstate & "&#060;P&#062;"<BR>end if<BR>IF addconn.errors.count &#062; 0 then<BR> response.write "Database Errors Occured" & "&#060;P&#062;"<BR> response.write MySql & "&#060;P&#062;"<BR><BR>else<BR> response.write "Everything Went Fine. Record has been added" & "&#060;P&#062;"<BR>end if<BR><BR>Next<BR><BR>AddRst.Close<BR>AddConn.Clos e<BR>Set AddRst = Nothing<BR>Set AddConn = Nothing<BR>%&#062;<BR>&#060;html&#062;<BR><BR>&#06 0;head&#062;<BR>&#060;title&#062;&#060;/title&#062;<BR>&#060;/head&#062;<BR><BR>&#060;body&#062;<BR><BR>&#060;p& #062;&nbsp;&#060;/p&#062;<BR><BR>&#060;p&#062;&nbsp;&#060;/p&#062;<BR>For some reason I get every product at once when I require is the the line by line as I check for a change in the txtQty field.<BR><BR>Is there a better way to get only the Line by Line items rather than them all at once?<BR><BR>Thanks<BR>David........