K
Kyle Powderly
I am creating a database to track our requests for
copyright permissions on several different projects. Each
project is assigned a two-five letter code. What I want to
do is generate a code number for each permission we're
seeking in that project with the Project Code prefix
(e.g., SR-42). THEN, I want to automatically generate a
code number for each correspondence (letter, e-mail, phone
call) that would use the permission code number as a
prefix (e.g., SR-42-047). Is there a (relatively) simple
way to do this, preferably without resorting to writing a
VB script (considering I don't know VB)? Thanks!
copyright permissions on several different projects. Each
project is assigned a two-five letter code. What I want to
do is generate a code number for each permission we're
seeking in that project with the Project Code prefix
(e.g., SR-42). THEN, I want to automatically generate a
code number for each correspondence (letter, e-mail, phone
call) that would use the permission code number as a
prefix (e.g., SR-42-047). Is there a (relatively) simple
way to do this, preferably without resorting to writing a
VB script (considering I don't know VB)? Thanks!