Results 1 to 2 of 2
  1. #1
    freeidea is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    2

    Primary_key not start from 1 when adding record in table

    hy all,i have create table personnel with other tables (job ,city...).and when i add any field ,in this table it give id 54 and 55 ..56...57...etc instead of starting by ID 1 because (it's autonumber)
    i have delete relationship ,but the problem still continuing adding Id 58...
    why it don't start from 1 then 2 ..3

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664

    Question Important Concept!!

    It doesn't matter what the autonumber field value is. Autonumber field types should NEVER be visible to the users.
    I know that an antunumber type field is used as an "EmpId" or an "Invoice" number, but the autonumber field is being used incorrectly.

    An Autonumber type field is designed to be able to have a unique number for a record. It should never have a real world meaning.

    See
    Autonumbers--What they are NOT and What They Are
    http://www.utteraccess.com/wiki/index.php/Autonumbers

    Read the above link. Then read it again. And for good measure, read it a third time.

    Also see
    Use Autonumbers properly
    http://access.mvps.org/access/general/gen0025.htm


    If you require a field with a number that begins at 1, you must "roll your own numbering system".

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-25-2015, 06:05 AM
  2. Adding new record to a table from a different form.
    By IncidentalProgrammer in forum Programming
    Replies: 5
    Last Post: 04-03-2015, 12:04 PM
  3. Adding New record to Table
    By Robert2150 in forum Forms
    Replies: 4
    Last Post: 03-24-2015, 10:42 AM
  4. Replies: 4
    Last Post: 08-14-2012, 07:14 AM
  5. Replies: 3
    Last Post: 10-28-2010, 07:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums