• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Creating Custom Counters

Access offers an AutoNumber field type that can be set to automatically generate sequential or random values. Although the AutoNumber field type is adequate for most situations, you might want to home-grow your own AutoNumber fields for any of the following reasons:

  • You want an increment value other than 1.

  • You don't like the AutoNumber field discarding values from canceled records.

  • The primary key value needs to be some algorithm of the other fields in the table (the first few characters from a couple of fields, for example).

  • The primary key value needs to contain an alphanumeric string.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint