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

[Dan Waters]

Thanks to everyone who answered my question!  It's all helpful.

Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Wednesday, April 29, 2015 5:13 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to Handle Multiple People with the Same Name

Hi Dan

There is only one way: use an EmplyoeeID. Either your own or one known by
the employee. 

Here each and everyone has a unique identity number (CPR - Central Person
Register) which is used by all relevant authorities and in companies for
registration of salary, holidays, sick periods, etc. 

A bit like the SSN# used in the US but much more thorough. New kids are
assigned a number within the hour, and all registered immigrants also
receive a number. Without a CPR number you are essentially lost.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Dan
Waters
Sendt: 28. april 2015 23:54
Til: 'Access Developers discussion and problem solving'
Emne: [AccessD] How to Handle Multiple People with the Same Name

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