Scenario
A library of film CDs. It is to keep track of all CDs that have been filmed for all different projects.
The problem is I cant find a way to automatically generate the CD Number I want.
Each project has a Prefix, for example the project New Build will have the prefix NB. The first...