Multi Updates

[Jamie Fryatt]

Hi gusy, you advice here woud be great.

lets say we have a ms db with two cols

id value
1 4
2 7
3 9
4 1

is there a simple way of updating all the value fields with one form? so i
can have the page lay the four value's out in a list, the user could then
edit them and hit update and this would update all the value fields!

i can update single records no problem but have no idea where to start with
this one.

Thanks

 

[Jamie Fryatt]

sorry if was unclear, ill try again.

one database, one table, two feilds (id, value) and four records.

i want to ahve a page where i list all four records (i can do that no
problem), each of the four values will apear in form boxs, i want the user
to be able to edit on the page any of the four all even all of them, hit
submit and asp to update each of the four records in one go, or with only
one click.

basicly can you update multipul records from one form? or does each one have
be submitted on its own, i was hoping there was some sort of loop in the
update process that could achieve this?