Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Gent (Belgium)
    Posts
    1

    Unanswered: unique nummers as primary key

    I'm creating a database where a new client in the library gets a unique number, chosen of a list of numbers that can be used. Only these numbers can be used. When a number has been assigned, it can't be used anymore.

    How can I get this in my database ? (VBA, macro ...?). If necessary I can give more info to get help.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: unique nummers as primary key

    Why not using AutoNumber?

    Anyway, if you have certain numbers to assign, store them in a special table, and mark them as assigned when you used them. You can even implement this mechanism in a multi-user environment, if you take the user into consideration.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

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