need to submit data to 2 records in database

[Guest]

i have a form where a visitor will input the wife's information on the left
side and the husband's information on the right.

i need to be able to use a single SUBMIT button to send the wife's info into
to the database on one line and the husband's information on the next line.

help! please?

john

 

[Thomas A. Rowe]

You have to hand code the ASP to create 2 insert record statement.
or

Why not just have a single record with fields for both?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

You have to hand code the ASP to create 2 insert record statement.

i was afraid of that. i'm not code-savvy enough to pull that one off. i
was hoping to be able to put 2 forms on one page. then have one submit
button send form 1 to the database followed by form 2.

Why not just have a single record with fields for both?

well yeah. that's what i had initially. however for reasons not relevant
to the question at hand, i need to generate 2 records in the database.

john