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