Data Primary key vs. Artificial (Autonumber) primary key
On Wed, 5 Dec 2007 04:07:06 -0800 (PST), Jamie Collins
wrote:
"If you're going to create relationships, they will
always be based on the primary key. You cannot change that."
Michael Gramelspacher said (paraphrasing): "I can create a FOREIGN KEY
REFERENCE (a.k.a. Access Relationship with referential integrity
enforced) based on a UNIQUE constraint, which goes against what Jeff
Boyce said about relationships always being based on the primary key."
You're right (about the meaning if not the attribution), Jamie - I
misinterpreted Michael's point.
John W. Vinson [MVP]
|