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

Dan Waters df.waters at outlook.com
Tue Apr 28 18:56:17 CDT 2015


Hi Susan,

I need to keep the names from causing problems.  I can't use a concatenation
of other fields.

Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Susan Harkins
Sent: Tuesday, April 28, 2015 5:35 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to Handle Multiple People with the Same Name

Depending on the number of records, even a middle name might not be enough.
You might want to include a birth date or even the ss# if you're collecting
those.

Susan H.

On Tue, Apr 28, 2015 at 6:15 PM, Jeff <jeff.developer at gmail.com> wrote:

> I've always just tried to include a middle name after the first name.
>
> Sent from my iPhone
>
> > On 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list