I'm trying to set up some basic data collection templates. I have one data base (contactlist) right now with two seperate tables (contact, basicquestions). I would like to read variables from the first table (table contact: variables q02,q03) and insert it into the second table (table basicquestions: variables q00, q05). The idea is to have one table with only contact information as well as having a second with individuals responses to questions. I need these two forms to be trackable so that when I eventually add a second set of questions on another page they get recorded to the same person who answered the other questions. I'm pretty sure I need to use an insert command to do this but:
1) I'm not sure where to place this in my page 2) I'm not sure what the command form is 3) I'm not sure how it will interact with the rest of the commands i have in Here is a run down of my webpages right now ********************************************************************* Page 1 - Contact Data Entry Form (submit redirect to processingform1.asp) Page 2 - Processing Form 1 - enters the data into data base table "contact" - directs to basicquestions.asp Page 3 - Basic Questions Page Form (submit redirect to processingform2.asp) Paeg 4 - Processing Form 2 - enters the data into data base table "basicquestions" - need to place insert command here so that the name information from the table "contact" is placed in the basicquestions table so all records for one person match up- redirect to thankyou.asp ********************************************************************* I'm not sure if that makes a whole lot of sense so feel free to email me or message me with any more questions. I have my code on a webpage so you can see it in full if that would be helpful. (I'll give out the info when asked) Thanks a bunch ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
