I am trying to figure out a method for auto generating a number in the add record form based on the next available number in a table. For instance, we would like to assign a specific contract # to each new record added to the database (if contract # 1999-crv-1 was the last record added to the database, we would like to assign contract # 1999-crv-2 to the next record). Any ideas?

1999-crv-1
1999-crv-2
1999-crv-3
1999-crv-4
1999-crv-5