automatic number for id

[Guest]

I want to create an automatic assigned ID number for each employee. I have
an employee database and each person has an ID -- I can't use SSNs (obvious
solution) with each new record, an ID number should be assigned and not used
over. Just not sure how to do this. Can someone help me... not good at
writing script.

 

[Guest]

In design mode of a table add a field and set properties to autonumber

 

[Joseph Meehan]

In design mode of a table add a field and set properties to autonumber

Please don't do that. People have all kinds of problems when they use
autonumber fields where people will see the numbers. Someone will look and
see that some numbers are missing like 1,2,5,6,7.. or they will want to add
a specific number.

It is fine if you know the odd way autonumber works will not cause a
problem, but it seems to cause a lot of user problems.