<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2>I've created a database for use by a group of
individuals (perhaps 20 users) in which the user will open a form and place a
request for a document number. I need a document number to be automatically
assigned at that time.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>An example of document numbers and their scheme are
as follows: </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>DC-2101-0001</FONT></DIV>
<DIV><FONT face=Arial size=2>DC-2204-0001</FONT></DIV>
<DIV><FONT face=Arial size=2>DC-2301-0001</FONT></DIV>
<DIV><FONT face=Arial size=2>LA-2605-0001</FONT></DIV>
<DIV><FONT face=Arial size=2>LA-2605-0002</FONT></DIV>
<DIV><FONT face=Arial size=2>LA-2605-0003</FONT></DIV>
<DIV><FONT face=Arial size=2>NR-2605-0001</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>It's the last set of numbers (0001, 0002, 0003)
that I wish to have assigned according to which first two sets (DC) and (2101)
are input by the user. Like if a user inputs "DC" and "2101"....I'd like the
system to automatically assign the next available number which would be "0002".
Therefore the document number assigned would be "DC-2101-0002".</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2><FONT face=Arial><SPAN class=440174415-09072003>Also,
t</SPAN>he bad thing for me is that we have already been using this database
(just one individual) and manually assigning these numbers. I don't know how it
would work out if we suddenly put the code in. Would it acknowledge previous
entries and assign the correct number?</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>If <SPAN
class=440174415-09072003>someone</SPAN> can help me with this, I'd be eternally
grateful.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=440174415-09072003>Virginia</SPAN></FONT></DIV></BODY></HTML>