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

Susan Harkins ssharkins at gmail.com
Tue Apr 28 19:11:32 CDT 2015


Why?

Susan H.

On Tue, Apr 28, 2015 at 7:56 PM, Dan Waters <df.waters at outlook.com> wrote:

> 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
>
> --
> 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