Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Autonumber fields (XP)

    Is it possible to configure an autonumber field such that it has some other number, a hyphen, then the autonumber component? For example, I would like like the autonumner field to be something like 100-XXXX or ABC-XXXX. Or, ideally, a number from a record in another table followed by -XXXX.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Autonumber fields (XP)

    No. You can format the appearance of the autonumber in various ways, but the number itself is purely a long integer. If you want to include something else, like a value from another table, you wouldn't make it part of the autonumber, although you could insert it into another field as a foreign key and then make the combination of the two fields the primary key.
    Charlotte

Posting Permissions

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