Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    40

    Red face Unanswered: Locking input ??

    Hi,

    in one of our databases we cannot use autonumbering , a project number is our main number , a sequence number can only be used 999 times .We have to add a new project number to input more.
    Now we have the situation that two users are adding new records and sometimes uses the same sequence number.

    How can this be prevented ??

    thanks in advance.
    Bye Erwin

  2. #2
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290
    set the field to no duplicates allowed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •