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 <*> 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/
