Auto Number based on another field

[Guest]

First Let me say- Im totally new at this and not very good! Im trying to set
an auto number based on another field.. For example I have 5 types of
products- those products all have a code in a table- I want to have another
table look at that Code and then set a unique auto number.

So so one code is GC and another code is GCP- I want the autonumber for GC
to start at 100 and the Autonumber for GCP to start at 300- Perhaps auto
number is not the way to do this.. But like I said Im new and my Access for
Dummies (LOL) is not helping!

Thanks in advance for any help and suggestions!

 

[Joseph Meehan]

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particular application.