Alpha Video Training
Results 1 to 2 of 2

Thread: Can't set default number in CODE field

  1. #1
    Member
    Real Name
    Steve Garman
    Join Date
    Feb 2006
    Posts
    19

    Default Can't set default number in CODE field

    I have asimple inventory database. The first field is CODE and is incremented automatically by one with each new entry.
    Somewhere i picked up a number of 9900 instead of where I should be at 3291. I can manually go in and change the numbers to what they should be and I've tried to reset the "startiing " number by puting "3291" in the slot for "What is the starting number" but when I eenter a new record and hit enter, the record I just entered changes to 9900 and the next field it then 9901. Where is it getting this wrong default number and how can I get it to be the number I want it to be?
    I've got lots to enter and don't look forward to going back and changing them all manually.
    Any help would be appreciated.
    Thanks,
    Steve Garman

  2. #2
    "Certified" Alphaholic
    Real Name
    Ohlen Cartmell
    Join Date
    Apr 2000
    Posts
    1,599

    Default

    The auto increment takes the number from the highest number in the index plus one more. Go into field rules and temporarly make the field a user entered field. Then delete the offending record and pack the table. Then reevaluate the indexes. Go back to field rules and make the field auto increment. While there go to the data entry tab and place .t. in the skip field. Now your next record should be one more than the highest entry.

Similar Threads

  1. field rule default value not set on a form
    By Alex Levy in forum Alpha Five Version 6
    Replies: 1
    Last Post: 11-19-2005, 07:50 AM
  2. xBasic code for default menus/toolbars?
    By michaelklein in forum Alpha Five Version 5
    Replies: 2
    Last Post: 10-20-2003, 11:43 AM
  3. set default dir for PDF
    By crimmelcp in forum Alpha Five Version 5
    Replies: 1
    Last Post: 05-22-2003, 03:29 PM
  4. How to set default browse & form?
    By Wayne P Lill Jr in forum Alpha Five Version 4
    Replies: 2
    Last Post: 07-20-2001, 07:51 AM
  5. Default Value in a Set
    By forskare in forum Alpha Five Version 4
    Replies: 6
    Last Post: 01-15-2001, 01:51 PM

Bookmarks

Posting Permissions

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