Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Brisbane, Queensland, Australia
    Thanked 0 Times in 0 Posts

    Autonumbers and undo event (Acc97 sr2)

    I have a quote form with an autonumber field for the quote number. I have a cancel button with an undo command in it.

    The undo command removes the record that was been started, but the autonumber sequence is not reset. ie

    record #7 begun but cancelled partway through, next record begun will be #8 not #7.

    This db is a 5 user setup over LAN. Is there another of doing this so that the numbering stays correct?
    "Heading for the deep end"

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Niagara Falls, New York, USA
    Thanked 0 Times in 0 Posts

    Re: Autonumbers and undo event (Acc97 sr2)

    Hi weyrman

    I made this rookie mistake as well. Charlotte, Mark and many others have answered this question many times.

    Autonumbers are not designed to provide a sequential number for invoice, po, quote no, etc.

    You will have to setup a table with last number used ot feed your sequential quote number so that its unique. Also need provision to adjust it if record started is canceled as described in your original post.

    Do a post search on autonumber and you will see all sorts of do's and don'ts for using autonumber.


Posting Permissions

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