We are attempting to create a database to track new files opened in our office. Until our file clerk retired this month, this task had been handled manually with paper on a clipboard. Our new file clerk is anxious to get out of the dark ages. Our numbering system for files ties to our client number in our accounting system and is very simple. The number is a five digit number. The first two digits represent the year the file is opened and the remaining three are a file count (05001, 05002, etc.) We would like to go back to 1999. We will have 2, and possibly 3, people entering the historical information and then it will revert back to just one person maintaining the information as new files are opened. Is it possible to autonumber the file number field? If it is not possible to do it with the historical information, is it possible to do it going forward and how do we go about it so that when a new year starts the numbering changes?
Also, our phone system is a separate set of numbers for purposes of tracking long distance calls by client. These numbers are recycled as files close and are not sequential. Is it possible to autofill a new record with the next recycled number and how do we do that? Do we tie that field to a table of recycled numbers and as each file closes, the number is entered into that table? If so, how do we get the numbers assigned to the new files as they are opened? Thanks for your help! Debbie ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h2of568/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122920385/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
