Denis wrote:
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.

An AutoNumber is also a generated value that is NOT an effective record number.
Its only guarantee is uniqueness, not a gapless progression of incrementing
numbers.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com