[AccessD] Primary Key Best Practices

Well having never thought of this...

that may be an indication of my brain capacity!
;o) 

I would imagine its just a consistency thing, once I start doing something I
generally do it consistently unless I have a good reason not to. This seems
like a good reason. However, I must await the inevitable drawback which will
be pointed out by someone who has thought this through more than I have.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman

Something like this seems like a no-brainer.  In fact, I think doing it the
first way actually confuses the design because there is no obvious reason
for having it that way.