If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Keeping autonumbering after going to SQL backend
I am in the middle of moving an Access2k3 Database to SQL. I have run into a
problem I need help with. My main table "OP" in Access uses they autonumbering field as the primary key. this PK filed also acts as our order number through the system. On main form "Add Record" starts a new record enters dates and times by default the PK field then saves. I need some suggestions on how to best duplicate the process of generating a sequential number like autonumbering for the form and OP table. Hope this isn't confussing. |
Thread Tools | |
Display Modes | |
|
|