Login form userid duplicates

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Login form userid duplicates

Post by burrina »

My database is setup so that I use the employees name, i.e. userid as the login user name on the Login form.
I decided to try and prevent duplicates by using the userid + the employeeid number so it would always be unique.
Of course I know how to prevent duplicate employees but still the issue with the id being unique.
Ex: Dave1 as Dave with EmployeeID as number 1 . Concantenate to dave1
Is there a better approach?

User avatar
HansV
Administrator
Posts: 78412
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Login form userid duplicates

Post by HansV »

I assume that the Employee ID is unique, so why not use that as login name?
Best wishes,
Hans

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Login form userid duplicates

Post by burrina »

Yes it is, but it is not very colorful. John Smith logs in as 12 but of course it would work. I think I have a handle on this now. Will post back if I run into a snag.
Thanks Hans and it's been a while.
Cheers