Inserting Records Into Two Tables HELP

[austinmoran]

I have two simple tables in SQL that are linked that I would like to update either (1) on a single ASP_VB page, or if need be, (2) on two separate ASP pages by passing a session variable (I don't know how to make this work, though). I have been able to create a form on one page, using the INSERT, APPLICATION OBJECT, INSERT RECORD WIZARD, and it works flawlessly. However, I need to insert from the form into TWO tables and I am not sure how to accomplish this.

Here are my table fields:
VOLUNTEER table:
VolunteerID (Key Field)
Fname
Mname
Lname
Address1
Address2
City
State
Zip
Phone

VolunteerCommittee table:
VolunteerCommitteeID (key field)
CommitteeChoice1
CommitteeChoice2
CommitteeChoice3
VolunteerID (Foreign field)

Any help you might be able to offer this DW newbie would be very much appreicated, for sure. I have been days trying to figure out how to accomplish this.

- Austin

 

[ChrisHirst]

one page, run two consecutive queries.



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[lebisol]

give this a look:

http://mostarnetworks.com/tmp/Insert.html

:--------------------------------------:

All around in my home town,
They tryin' to track me down...