[AccessD] 2 quick questions

And in the case of social service agencies that deal with illegal aliens,
the SSN can also be duplicated.  I have seen that numerous times
working with them on my application.

At 01:18 PM 5/27/2011, you wrote:
>Date: Fri, 27 May 2011 09:52:16 -0700
>From: Charlotte Foust <charlotte.foust at gmail.com>
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] [Spam]8.31 Re: 2 quick questions
>Message-ID: <BANLkTik3fAoGcxkDv8Rp7zd_WzQ-rgZm1Q at mail.gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1
>
>I've argued with experts about IKs like social security numbers.
>Their arguments always seem to boil down to, "Well, they don't USUALLY
>change, so that's OK."  I prefer to violate strict normalization and
>include an IK that CAN be changed and an autonumber that can't.  Then
>when the IK must be changed (i.e., wrong SSN), the connections among
>tables aren't lost.

Robert L. Stewart
www.WeBeDb.com
www.DBGUIDesign.com
www.RLStewartPhotography.com