I wouldn't think that the study id needs to be on the pop-ups. I assume that they will simply pass information back to the main page for inclusion in hidden fields in the form you'll be submitting to ASP?
Or do you want these pop-ups to invoke ASP themselves? In this case you risk creating their entries in the database before the study entry is created in its table - presumably a database link violation anyway. One way to do it would be to have the ASP page that creates the study table item then go on to present the user with quotes and biblio facilities. I.e. user enters study information and submits it, user next sees a page that allows quotes and biblios to be entered. For something like this, chart out the database actions that need to be done - in the order they need to be done - then design your ASP and pages to support that. Dave S ----- Original Message ----- From: Mike Crain To: [EMAIL PROTECTED] Sent: Thursday, May 13, 2004 7:37 AM Subject: [ASP] Updating tables with ID's that do not yet exist. I'm trying to write an ASP page (Classic, not .NET) for a study tool and I'm running into problems. Here is the scenario: I go to a form and fill in various text boxes, or dropdowns. Then comes the part I need some advice on. I have two areas "Associated Quotes" and "Bibliography". I want to store these in a separate table as shown below. Study Quotes Biblo ____________ ______________ ____________ | studyID | | QuoteID | | BibloID | | Date | | StudyID | | StudyID | | User | | QuoteText | | Book | |<Others> | |____________| |__________| What I want to do on the page that you fill out the study page, to have a way to create entries in the other tables. But I don't have a study ID until the form is actually submitted and a SQL Insert Stored Procedure is called, so I can't do a simple pop-up box. I could create the studyID when you hit the page, but I want to avid blank entries if the user hits this form and just hits the back button. Does anyone have any ideas? Am I making this too complicated? Would this kind of thing be easier to run in .NET? I was trying not to use that as a solution as I do nit really know a lot about .NET as of yet. Mike C --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- ------------------------------------------------------------------------------ Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.683 / Virus Database: 445 - Release Date: 12/05/2004 [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor ---------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM ---------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> 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/
