[AccessD] How to Handle Multiple People with the Same Name

[Gary Kjos]

We use first initial last name as a user ID.  If the user ID is
already used, we append a number. DANDERSON2 etc.

DANDERSON is end dated but still exists. If he returns he could be
reactivated or possibly become DANDERSON3

GK

On Tue, Apr 28, 2015 at 4:54 PM, Dan Waters <df.waters at outlook.com> wrote:
> Suppose you are writing a system which sets up profiles for all users.  And
> you have two users whose names are both Dave Anderson (common in
> Minnesota!).
>
>
>
> How have you handled this?
>
>
>
> Then, one Dave Anderson leaves the company, and later another Dave Anderson
> is hired.
>
>
>
> Now what?
>
>
>
> If you've dealt with this or just observed a system that works please
> respond.
>
>
>
> Thanks!
>
> Dan
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-- 
Gary Kjos
garykjos at gmail.com