[AccessD] Primary Key Best Practices

Jim,
This is something I haven't seen before and is in my early morning mind,
quite brilliant! Are there any drawbacks to doing this?

I can't imagine it would be much of a difference (size or performance wise)
in any of my applications / databases but it is certainly something worth
considering implementing in the future.

Always open to technical improvements...

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

True, but in the case of a M to M table your just introducing another column
and a index that really is not needed.  It seems silly to me to have
something like:

tblLinking
LinkID - Autonumber - PK
BookID - Long - CK1A
AuthorID - Long - CK1B 

Instead of

tblLinking
BookID - Long - PK1A
AuthorID - Long - PK1B


  just for the sake of having an auto number in there.  The BookID and
AuthorID already form a unique pair and they typically would not be used as
a foreign key in another table.