What I would like to do is add records from a view to a table based
upon user input. What is making it hard is since I can't give an
identity field to a view I don't know how to call to a certain row.
What I have is a form that brings records from a view into a page and
places a text box at the end of each row:
do until rs3.eof
stPurchase= rs3("PURCHASE ORDER NUMBER")
strLine = rs3("LINE NUMBER")
strPDate= rs3("PURCHASE DATE")
strPartNo= rs3("STOCK NUMBER")
// set my variables for the fields being brought in
<tr>
<td><%=rs3("PURCHASE ORDER NUMBER")%></td>
<td><%=rs3("PURCHASE DATE")%></td>
<td><%=rs3("STOCK NUMBER")%></td>
// display fields being brought in
<td><input type="text" size=10 name="estDel" value=""></td>
// putting a text box behind fields brought in
</tr>
rs3.movenext
loop

I want to be able to do something like this:
if request.form("submit") <> "" then
// if something has been submitted do this
dim myArray
dim strDel
// dim array and input value
strDel = request.form("estDel")
myArray = split(strDel, ",")
// get the separate values of strDel to try to use as a way to find
the row of data
for i = 0 to UBound(myArray)
if myArray(i) <> " " then
// if there is a value entered into the text box then insert the
values in that row into a table
insert into table1 (PO, LN, PD, ST, DELDATE) Values ('" &
strPurchase & "', '" & strLine & "', '" & strPDate & "', '" &
strPartNo & "', '" & strDel & "')
end if
next
// check next


If anyone knows how to do this or a different way please let me know.
Any help would be greatly appreciated!