2. ASPRunnerPro General questions
  3. Master Table to Detail Table after clicking SAVE
This topic is locked

Master Table to Detail Table after clicking SAVE

 		1/5/2006 1:24:05 PM
ASPRunnerPro General questions
B
 baller author

I have a question about the master and detail tables. For example I have a master table called ORDERID and a detail table called DETAILS. They are linked together by the ORDERID field as the keyfield.
Currently I have to go to the Master table (ORDERID) and create a new Order ID. Once I click save the record for the ORDERID is created. Now to add items in the detail table I have to search for the order ID and dlick on the link to Details to start adding items. I was wondering if I could elminate this step of finding the Order ID in search and then clicking on details to start adding items.

Is it possible to to create the ORDERID in the master table and upon hitting save go to the details table associate with that OrderID?
thanks ahead of time
Steve
oh yeah also I should be entitled to the freeupgrade to 4.0. I have emailed customersupport about the issue but they have yet to respond. The problem is I had someone else order the product for me and that person no longer works with me so the code is probable emailed to her instead of me. Anyways let me know if you need anymore information from me. Thank you
Alberto 1/5/2006

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7334&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> That simple thing would help... When page is a mastertable_add.asp and mastertable_edit.asp a third button pointing to detailstable_list.asp allowing us to go directly to details list page. Then you can Add, Edit, Delete, etc. detail records asociated to the master.
|Save| |Reset| |Details|
Sergey Kornilov admin 1/5/2006

Steve,
I don't think this is very good practice however you can do this using events.
When you add new record you can search for orderid and create a new order if it doesn't exist.
PS. Registration key was sent to you already.
B
 		baller author 1/5/2006

can you give me more detial on how to do this using events with ASP RUnner? thanks
Sergey Kornilov admin 1/6/2006

No, I cannot give you generic advise that will work.

It depends on your database specifics.
B
 		baller author 1/6/2006

No, I cannot give you generic advise that will work.

It depends on your database specifics.


ok thanks for your help anyways I think i figured it out <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7372&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />