Adding master and details records with single click

[primagic]

I need to add a new master record (order) then order details for that new order with a single click. What is the best approach to this?

I was going to have a form where you enter details for the master record, then another form to enter the order details, click a single button and it adds the master record first, gets the ID from that entered record and then adds the detail records and use the ID from the master record created.

Any easier or more structured approach?

 

[jbenson001]

I would have a single form where you enter all the information. On the click of the button, validate all of the inputs. When valid, call a stored procedure that inserts the master order record. Pass back the new id(from an identity column if using sql server).
Then, use that id in a call to a second sp to insert the details.

You basically have the concept already designed from what I can tell in your post.

 

[jbenson001]

On second thought, I would use one procedure all to do both inserts. In the SP, wrap both INSERT calls inside of a Transaction.