Sequencing Alpha-numerics

[Terry]

I have two different fields that I would like to
sequence. Field 1 is an alphanumeric field and is unique
within the table. The format is "4E-##". I simply would
like to increment + 1 for each record entry.
4E-01
4E-02
ETC...

The second field may be a more complex problem. I have
two fields that need to interact. Field 1 is a
2 Character Text field. Field 2 is a 3 character
integer. I would like field 2 to increment only when the
count for Field 1 value increases. For example record
one, Field 1 = AD and Field 2 = 001. If record 67 is the
next time that Field 1 = AD; then I would want Field 2 to
increment and = 002. Do I need to create a joined field
to make this occur?
Field 1 Field 2 Field 3
AD 001 AD001
SC 001 SC001
AD 002 AD002

 

[Jeff Boyce]

Terry

What you are describing sounds a lot like the topic of "Custom
Autonumbers" -- which you'll have to create a procedure to handle. Check
the Google.com listings for MS Access with that topic, or the MVPS.Org site,
also on topic
http://www.mvps.org/access/