Title: ACCGeneral Primary Keys: Surrogate or Natural
Symptom: You want to use a consistent approach to creating primary keys in your databases. You are aware of a debate concerning whether natural keys or surrogates are generally preferable.
Subject: This tutorial discusses the theoretical background that should inform the choice of natural or surrogate keys to be used as primary keys.
Applies to: all versions of Access and databases generally Tested in: n/a
Skill level: basic knowledge for intermediate and advanced users
Author: Glenn Lloyd Date: February 12, 2005
Credits: Utter Access members who have contributed to forum discussions on the topic, Microsoft-AccessSolutions.co.uk (now www.databasedev.co.uk), and an article by Michelle A. Poolet in SQL Server Magazine (http://www.win2000mag.com/SQLServer/Article/ArticleID/23449/23449.html)