How to insert multiple records to the same table with a multi-fields form

[PiGei]

Hi all,
is it possibile to insert multiple records in the same table?

I imagine to build a multi-rows form, with the same number of fields per
row and, pressing the button, to insert all the data in the db table.

The db is Access.

How to do it?

Thanks
PGei

[Brynn]

The easiest thing would be to have the fields with the same name, and ending
with the row number

id1, name1, address1, city1, state1
id2, name2, address2, city2, state2
id3, name3, address3, city3, state3 etc...

then a hidden field telling you how many rows ...

hidden field called totalRows

then on your results page just do a update for each row

for n = 0 to CInt(Request.Form("totalRows")
yourSQL = your update statement where id = Request.Form("id" & n)
'// and the values are the form name with n for the number

next

I hope this helps point you in the right direction.

I will be creating a grid here shortly and putting it on my site ... it will
be a couple months though, for I am building some other open source things
first.

--
Brynn
[url]www.coolpier.com[/url]

*****
I reply and post to this newsgroup in an attempt to help other users.
I in no way guarantee the effects of scripts posted ...
and sometimes post partial scripts, untested to point users in the right
direction.

ALWAYS test my and everyone elses scripts before use ... duh ;)
*****
"PiGei" <james_milanNOSPAM@hotmail.com> wrote in message
news:%23AZ9cgV8DHA.4060@tk2msftngp13.phx.gbl...

> Hi all,
> is it possibile to insert multiple records in the same table?
>
> I imagine to build a multi-rows form, with the same number of fields per
> row and, pressing the button, to insert all the data in the db table.
>
> The db is Access.
>
> How to do it?
>
> Thanks
> PGei
>
>