Hi guys!

I have an order table and an order detail table in a database. I am trying to create insert forms using ASP for these so the user can insert new order details. I created an order details table to solve the many to many relationship between the order table and the product table. I am not sure how to do this... any ideas??

What i have so far are two ASP pages one with an insert form for the order table and one for the insert form for the order detail table. Once the user enters details of the order in the first form they are transfered to the page for the order details table, in this form they fill out the product details for the order. I need to be able to link these forms together somehow. I thought that the order details table and form would hold the order ID from the first insert form but i cannot get the ID to pass. I have tried using master detail page set but this doesnt work in this situation.

I would have thought that creating insert pages for order and order details tables would be quite common.. i cant find anything!

Any ideas would be great!

I am a student on placement with not long left and i need to finish my application ASAP. I have asked a few other questions on this forum that nobody seems to know the answer to. PLEASE HELP!

Thanks!
GLT

would use a stored procedure to join and insert the ID into the details table??

any ideas??

Try to go to the next page for the order details to enter, with the order main details as hidden fields.. then use two different queries to insert both the tables..
Procedures possible when u have the master table values GLT..

how would i do this? I thought only one insert was allowed per page??

if i did use the method you suggested it would not solve the ID problem which was the original problem. I need to add the ID of the order that has just been entered into the orderline table as a foreign key. This is the original problem how can i do this??

Thanks

once u come into the order details From the master order page, u will have the ID right.. insert both at same time.. means write the queries according to the situation..

I cann't understand why you cann't pass id.
Simply get the last inserted id and pass it to next page.

In the order page (1st one), add record in to order table and get the order_id
using the following syntex

pass this value as hidden variable in next page and then you can use this to populate the foreign key in order details table.

I cant do it because ive never done it before... have to start somewhere somehow.
Thanks for your help! ill try that now.

Hi!

I cant seem to get it to work. I am a newbi to this sort of thing so im not sure exactly where to put this code or how to edit it (if at all) for my page.

Can someone please help me and tell me what i should do. I cant find any tutorials or anything on this so I cant learn any other way.

Thanks
GLT