I'm building a shipping system that has a one-to-many relationship. I want the user to create the shipping header (who, where, when, etc)....then select all the items on the shipment...then press submit to create the shipment.

So I can create it in two-parts where they enter the header details, insert the rec then create the child records but this it too messy. The primary key between the 2 tables is an autogenerated number. What I want is the user to be able to create it all on one form or via a wizard...but the challenge I can't figure out is how to connect the two since the key is autogenerated. How do I insert the parent, then find the key and then insert the child recs?

Thanks for any guidance!


Thanks,
Erik

what DB are you using?

Currently it's an Access db for now...I will be moving it to a SQL one in the near future.

Thanks!

Thanks,
Erik

I'm not familiar with Access. With sql server there is @@Identity and Scope_Identity that will give you the Identity(auto generated) value of the last inserted row. Then you can send this value back to the front end, and use it for the Insert into the child table.

Thanks, I'm upgrading to SQL Express now so I will give that a try.

Thanks,
Erik

Good luck :)