Govinn,

Thank you for your reply.  However, this won't work, because there is no relation between the clientmaster and dmvrequest table.

Now you may ask, then why am I doing this.  I'm...

sushila 

Forgive my ignorance, but how do I tell the stored procedure what variable goes where?  Right now, I just my variables defined...

I don't think I can do this in ASP, because I'd have to pass the variables like so:

'all the variables from all the forms

SchoolName = SchoolName      

SchoolCounty = SchoolCounty

SchoolType=SchoolType

etc....

set dataConn = Server.CreateObject("ADODB.Connection")

dataConn.Open ...

Remi,

Oh yeah, thanks.

BTW...why would I do all the inserts in the stored procedure? 

My issue with this is, how the heck would I...

Thank you for all your help guys,

When creating the stored procedure, won't I need to do something like:

create procedure prc_modulename_insertbig (

@SchoolName       varchar(50),

@SchoolCounty      varchar(50),

@SchoolType       char(1),

@SchoolAdd1        varchar(100),

@SchoolAdd2       varchar(100),

@SchoolPhone      char(11),

@SchoolFax          char(11),

@SchoolIP           ...

Sushila,

1) The five inserts you have to do!

I have to insert data from 5 forms into 5 different tables. So one of the inserts would look like this:

INSERT INTO School(UniqueId,...

Even if I do somehow manage to write the stored procedure, how do I handle to uniqueid?  How do I link all the tables together?

Thank yous

Ok , I can do an insert, and I can put together an error check, but how would I handle the UniqueId that servers as the key to link...

It sounds beautiful...but also extremely difficult.  I wouldn't even know where to start!

DSP,  I agree with you on the first step; I will do the INSERT on the last page.

As far as table structure goes, I have 5 tables: School, Students, Professors,...

Thanks for all your help Remi. 

I think I got it working:

strSQL="SELECT SQ.*, DEdescription, DEenteredDate

 , ST.AOcontactNameLast AS SendTo

 , BT.AOcontactNameLast AS BillTo

 , R.AOcontactNameLast AS Requestor

 , DE.*" &_

FROM schoolrequest SQ" &_

 LEFT JOIN academicoffice ST ON SQ.SLsendToId=ST.AOid

 LEFT JOIN academicoffice...

I'm still going for it...although I'm thinking of splitting the one query into two.  So the first one would be:

SELECT SQ.*

 , ST.AOcontactNameLast AS SendTo

 , BT.AOcontactNameLast AS BillTo

 , R.AOcontactNameLast AS Requestor

 ,...

SLFine,

I think my biggest issue now is that I felt as if I was getting somewhere(with Remi's invaluable guidance) with the original query, but now I'm totally lost as what...

The form is just one form though.  It has maybe 15 total fields and pulls information from three tables.  I don't understand what is wrong with that.  All the data...