Autonumber fields make excellent Primary Keys. That's what they were
designed for, and as Rick said, they are not designed to be a record number.
They are used only to create a guaranteed unique value for relating tables.
I use them in every database and highly recommend their use.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L



"Denis" wrote in message
...
Access allows a table to have an autonumber field which could be
considered a
record number.

In an application I am involved in developing there are a number of code
tables which are using the autonumber field as the code. This is
autonumber
code is then used in the tables holding the data.

I am seeking opinions on this approach. Is this a reasonable practice?
What
are the dangers of doing this?

I come from a mainframe environment where this sort of approach is avoided
by generating a unique code value which is not an effective record number
as
a record is added.
--
Denis