Re: Multi-Field Primary Key

So I'm the chump who's being duped by the slick-talking autonumber heretics,
is that it?
I can find all sorts of arguments pro and con on any topic, so the existence
of advocacy for one position or the other does nothing by itself to sway my
views. Autonumber works fine for my purposes, but my point, which you
ignored, was that even if I was to accept your position on "natural" keys,
what is "natural" about a phone number? Unless you are sorting by phone
number to find gaps or something like that the ordering of a phone number
field is surely as arbitrary as an autonumber field.

"Jamie Collins" <jamiecollins@xxxxxxxxxx> wrote in message
news:1168265553.697929.225810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

BruceM wrote:

I'll just mention that a many people, including Access MVPs, consider
autonumber to be a perfectly acceptable and efficient choice for PK.

I'll just mention that many people, including the Emperor's most
trusted advisors, considered his New Clothes to be a perfectly
acceptable choice for a state occasion <g>.

Researching a natural key can involve time and effort (though usually a
google search will quickly reveal an industry-standard key, ISO
standard, etc). Designing your own key can be hard work. Is there
anything simpler than incrementing an integer? Sure, an integer that is
incremented for you!

It is mere coincidence in this case that 'the easy way out' is the not
'the road less travelled'?

Jamie.

--



.

Relevant Pages

  • Re: Multi-Field Primary Key
    ... autonumber to be a perfectly acceptable and efficient choice for PK. ... trusted advisors, considered his New Clothes to be a perfectly ... anything simpler than incrementing an integer? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Create a text box that automatically counts in forms
    ... If the number is to be seen by the user, I would not use autonumber, since ... there will almost ineveitably be gaps in the number sequence. ... for one method of adding an incrementing number using code. ... >> entry I would like the claim# to be something like CCA-1 and then count ...
    (microsoft.public.access.forms)
  • RE: Autonumber upon opening a form
    ... I've changed the field in the database from Autonumber to a text ... that you will experience gaps in the numbering sequence. ... Year, Month, and an incrementing number as in 2006040001, 2006040002, ... not actually created until you start entering data. ...
    (microsoft.public.access.forms)
  • Re: Increment Number Format
    ... You can't use an Autonumber to accomplish this. ... > I have a incrementing AutoNumber field set up for an Invoice Numbering> System. ... > I would like to format the number like this and increment it by 1 each time> I create an Invoice. ...
    (microsoft.public.access.forms)
  • Re: Help Needed With Primary Key
    ... the links in my first reply show you a way to add incrementing ... numbers (a sort of simulated autonumber that avoids gaps). ... However, you can roll your own "autonumber", which will eliminate gaps. ... the Primary Key is incremented, even if the record is not saved. ...
    (microsoft.public.access.gettingstarted)
Loading