G
Guest
I have a multiuser database that uses the ProjectID field (an autonumber
field) to create the project number for every new project. Some users are
complaining that when they attempt to input a new project, they are receiving
an existing project number as the "next number" and since the database is set
up so that all the ProjectID's must be unique numbers, it will not allow them
to create the new project entry. Is this happening because there are
multiple users in the database who may also be creating new projects? If so,
is there some code I can place into my input form that will "release" or free
up the next available number for the concurrent user?
field) to create the project number for every new project. Some users are
complaining that when they attempt to input a new project, they are receiving
an existing project number as the "next number" and since the database is set
up so that all the ProjectID's must be unique numbers, it will not allow them
to create the new project entry. Is this happening because there are
multiple users in the database who may also be creating new projects? If so,
is there some code I can place into my input form that will "release" or free
up the next available number for the concurrent user?