AutoNumber Question

Hello,
As far as a Primary Key is concerned (for an Employee Table)
I have read numerous times on the boards NOT to use the Auto Number feature,
I'm not sure exactly why, although I could see where the random number can
confuse some.
Would anyone recommend using a SSN instead? It will be unique, and it will
serve as a good reference to the employee.
Any thoughts of why or why not?

Thanks Again !

VL


.

Relevant Pages

  • Re: serial numbers in tables
    ... it would get an auto generated serial number for each employee entry. ... field then an auto enter serial starting 1, increment 1 is used. ...
    (comp.databases.filemaker)
  • Re: Auto Number
    ... An auto number would incriment each time a new record is added. ... why are you using an auto-number for employee number at ... should be assigned using some meaningful method. ...
    (microsoft.public.access.forms)
  • Re: serial numbers in tables
    ... get an auto generated serial number for each employee entry. ... A primary key field MUST be defined with certain characteristics: ... The PK field can be either a number or text type; if defined as a number field then an auto enter serial starting 1, increment 1 is used. ...
    (comp.databases.filemaker)
  • Re: I want to put serial number too.
    ... number, employee name, section, designation, extension, ... >In the same time if I did not give auto number what will happen? ... If you want to reuse the number, or even have it visible for users at ... I would create a new department, named "Employee Transfers", and ...
    (microsoft.public.access.forms)
  • Count in a Query
    ... I created a query from my employee table. ... count feature but I cannot figure out how. ... Prev by Date: ...
    (microsoft.public.access.queries)