[quote=sadesdrk]Hi Mosey Posey...Matt...Kently...hopefully Kent took a cold shower this morning...;D[/quote]

[quote=Sir Toose]If you plan to use this going forward I would use the emp#'s. The name fields are not normalized anyways so this would be the quickest fix.[/quote]

[quote=mightymose]Chances are high that we will hire two people with the same last name, but never the same last and first... the actual # assigned to them isn't important for this program as long as the data entry screen lists their first name :)  Go ahead and make the call whichever way you feel is best and if you decide you don't want an arbitrary number let me know and I'll send you the employee #'s... they are not consecutive, but I don't think that matters...

Howdy Sady Lady![/quote]

[quote=spudracer]Crap..just pissed off a bee and I don't know where it's hiding..[/quote]

[quote=spudracer]Bored bored bored...[/quote]

[quote=spudracer]Well Hello Sadie.  :D[/quote]

[quote=Sir Toose]Hi Sadie! ;D [/quote]

[quote=Sir Toose]Again... you know your business and i don't... what are the chances you'll hire someone with the same last name as another? It's definitely preferable to establish a primary key in a number field or a combination of text fields... let me know..[/quote]

[quote=sadesdrk]Blah blah blah blah blah blah blah blah blah blah computers blah blah blah HTML codes blah blah blah blah blah...etc. Hi boys!;D[/quote]

[quote=mightymose]I thought of the same thing... which is why I listed their full name in the drop down menu at the data entry stage... if you don't think that will work just let me know and I'll e-mail you their employee #'s[/quote]

[quote=Sir Toose]Okay... I always look far out in the future and I didn't know how far you were going with this... or if you would ever have 2 emplyees with the same last name.... just looking for commonalities so I can join the tables together.[/quote]