Auto Number Client Matters

C

carrol

When we open a new client file, we code it with a matter number like 05-201
(05 for the year and 201 for the # of the matter) How do I create a primary
key or at least where it will automatically enter the next sequential number
when I enter the client info (05-201, 05-202 etc). I also want it to start
over each year (06-01, 06-02 etc).

Thank you for your help!
 
V

Van T. Dinh

It is better to store 2 items of data in 2 separate Fields (and your
"intelligent" key consists of 2 items of data).

You will need to ensure that ALL data entries are to be done via Form so
that you can use a Form Event to generate the SeqNo for the appropriate
year.

Search Google for Custom Number Sequence.
 
Top