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!

Look at the following post:

post