Re: Multi-Field Primary Key


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.

--

.

Loading