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

[Gustav Brock]

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