striker222
Programmer
We have an access 2000 database at work used to log purchase orders . The primary key is a numeric field(LONG) named "PO_Number" which really is a sequential number. We manually enter the next number everytime we create a new record.
What I am trying to do is have Access 2000 automatically increment the value of this field for each new record without having to type it in. To make it short, I want to have it act as an Autonumber data type without making the first record start at 0 (our PO #'s started at 100500).
I came up with the idea of writing an expression for the Default Value for this field, but can't get it to retrieve the Max(PO_Number) and add 1 to it.
I can easily do this by making a form in VB, or ASP for that matter, but management want's us to use the datasheet view in Access. Thanks for the help, hope this wasn't too confusing.
What I am trying to do is have Access 2000 automatically increment the value of this field for each new record without having to type it in. To make it short, I want to have it act as an Autonumber data type without making the first record start at 0 (our PO #'s started at 100500).
I came up with the idea of writing an expression for the Default Value for this field, but can't get it to retrieve the Max(PO_Number) and add 1 to it.
I can easily do this by making a form in VB, or ASP for that matter, but management want's us to use the datasheet view in Access. Thanks for the help, hope this wasn't too confusing.