Auto Number Client Matters

salam

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!

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.

--
HTH
Van T. Dinh
MVP (Access)




"carrol" wrote in message
...
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!