Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unanswered: inserting a master record and multiple detail records

    Example ... shopping cart application. I want to write a new order header record to the order table and then use the order number that is generated (autonumber) in the order detail table immediately afterwards in order to write all the items they want. I am using Access as my DB.

    I know I can do a search for a max number but what if person 1 enters an order, I write to the order table, Person 2 enters an order before i can complete the search. My order detail table will have the wrong order number associated with the details.

    Thanks!

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Look at the following post:

    post

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •