Jim Hewson
JHewson at karta.com
Tue Jul 24 10:24:23 CDT 2007
That's where I'm at now! And the rain is coming in! Jim jhewson at karta.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, July 24, 2007 10:10 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Primary Key Best Practices Head for the storm cellar, quick!!! Charlotte -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, July 24, 2007 8:05 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Primary Key Best Practices LOL, here we go again. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson Sent: Tuesday, July 24, 2007 10:55 AM To: Access Developers discussion and problem solving Subject: [AccessD] Primary Key Best Practices I need a few good references (preferably electronic) on the Best Practices for defining Primary Keys (PK) Here at the office we have had a few heated discussions about primary keys. I don't' mean to stir the pot on this list, just curious what others think. 1. All tables should have a primary key even though it will not be used as a foreign key (FK) in another table. 2. PKs should always be an autonumber (Access), Identity (SQL) or GUID. 3. Avoid complex PKs such as two PKs from two other tables. 4. Avoid complex PKs such as two fields from one table. You could probably come up with some more. Thanks, Jim H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com