wacara
04-23-2007, 02:32 PM
I desperately need help!!
I will try to explain this as best as I can. I have created an application that allows a user to request a quote by filling in the form fields and when the user hits the submit button the application assigns an id number to the request, sends an email to both the user and me and also inserts the data into the database.
Now here's my problem, I need this application to be able to have multiple detail lines under one id number. It should work like placing an order with multiple lines but only one order number. Same fields in the details but different information.
Can anyone please tell me how I can accomplish this task. I know it can be done, I just don't know how to do it. There are 4 pages to this application - 2 that gathers and inserts the data into the customer info db and 2 that gather and insert data into the quote_requirements db. Below is the code for the page that accepts and inserts the details. If you need more please let me know.
I will try to explain this as best as I can. I have created an application that allows a user to request a quote by filling in the form fields and when the user hits the submit button the application assigns an id number to the request, sends an email to both the user and me and also inserts the data into the database.
Now here's my problem, I need this application to be able to have multiple detail lines under one id number. It should work like placing an order with multiple lines but only one order number. Same fields in the details but different information.
Can anyone please tell me how I can accomplish this task. I know it can be done, I just don't know how to do it. There are 4 pages to this application - 2 that gathers and inserts the data into the customer info db and 2 that gather and insert data into the quote_requirements db. Below is the code for the page that accepts and inserts the details. If you need more please let me know.