[AccessD] Primary Key Best Practices

John Bartow john at winhaven.net
Wed Jul 25 10:30:32 CDT 2007


While I agree with you  on the subject matter at hand - I don't recall
seeing this as criteria for a primary key before. Is this a Colbyism or am I
just not quite awake yet?

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

2) Has no meaning.  From the perspective of the CHILD record, the FK is
nothing more than a pointer back to the parent record.  As such it should be
a behind the scenes, never directly viewed artificial construct designed to
do its job as efficiently as possible.




More information about the AccessD mailing list