I am modifying a database for a charity and need an auto-generated serial number for their fund-raising events that appears like this 2001/001, 2001/002....2002/001, 2002/002 etc.

The first part of the number is generated from the date of the event but I am unsure how to do the changing number part. What I see as my difficulty is that some events are planned in the previous year. So event 2002/002 might be created before event 2001/010.

How do I ensure that the second part of the serial number relates to the correct year?

If I'm thinking wrongly please let me know.

dt

There are a couple of solutions posted on databasepros.com. What I do is create a self-relationship based on the year (2001) and create a serial number (your 005) that is the [max+1] of all the serial numbers that match the relationship. You have to use a script.