If they don't already, the two tables need to have a "relationship" established (they must have at least one common column). Since you want to eventually have a second set of questions, you need some type of login (even if they are just typing in there name) so that you can find that person's record in the database. Since you don't want them to have to re-enter their name at the basicquestions page, you can put a hidden field that contains there name (or whatever unique thing you are using to identify them)on that page to track them. Go to this link http://www.learnasp.com/learn/stateproscons.asp to get an overview of the many ways to do this ... hidden fields just seems easier to me, but cookies & session variables are explained there as well.
Hope this helps! --- In [EMAIL PROTECTED], "shadow_snd_2002" <[EMAIL PROTECTED]> wrote: > 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/
