I have a field in a table ( Clients ) called Clients_Client#, which is a text field. Each year we start a new group of clients numbered as follows:
2011-01
2011-02
and so on.
I would like to fill in this field automatically when a new record is selected to avoid typos and duplications. Any ideas would be appreciated.
Regards,
Bill