How do I setup a table that provides incremental number increases

K

Kyla Dockery

I have already set up a table in Access. In my form I have it set up to
where I can choose from a list box in one field, what I would like for my
next field to do is add a corresponding letter (the first letter of the
choice from my list box) and automatically populate a five digit # (00001)
which is got from another table. My letternumber combinations have to be
sequential for each of my four choices in the list box. For example:

Document Type: Could be Tooling, Electrical, Pneumatic, or Facility
depending on which is chosen in the list box.

Document Number: Should be either T00001, E00001, P00001, or F00001, with
each one increasing one increment any time a new record is entered for that
particular document type.

Please don't say that this information is redundant, I need for it to be set
up this way! Can anyone please help me, I would be incredibly grateful?
 
T

Tom Wickerath

Hi Kyla,

I won't say that it is redundant; it is, however, known as an "Intelligent
Key", which should not be taken as a compliment.

Try a Google Advanced search for Intelligent Key. Here is a set of results
for author=John Vinson (an Access MVP). You will likely find the answer among
the various threads in this result set. If not, widen your search by removing
the author name:

http://groups.google.com/groups?as_...81&as_maxd=22&as_maxm=3&as_maxy=2006&safe=off


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
K

Kyla Dockery

Tom

Can you help me to figure this out? I know now exactly what needs to be
done, but I need help with the formulas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Difficult Question-Help with setting up specific functions for a F 3
In Access, automatically populate a field based on another field? 5
Pasting a cell into bookmarked table from excel vba 1
How do I clear a form? 0
How do I create a set of words that are flagged? 0
Creating Labels Over 3-Up Image 2
a table in this document has been corrupted... 0

Top