I have an asp.net vb form that inserts a record into an Access Dbase. One of the fields is an autonumber field (ordernumber) that is generated in Access when the data is added to the dbase.
My problem is this:
I need to set a session variable equal to the ordernumber that is autogenerated right after the record has been added to the dbase.
I originally thought about passing a form variable to a page that would retrieve the record and then grab the value for the ordernumber and set the session variable but I don't have any fields in the form that I could reliably use to differentiate each record. For example, I thought I could use the entered phone number but it is possible for the same phone number to be used for more than one record. Same is true for name, more than one order could come from the same person.