My database houses four types of key documents: bylaws, resolutions, policies & procedures. We want each document's number to be its "ID" in the database however, some of them have the same number (policy 001, bylaw 001, etc.). There are hundreds of them so it is too late to change the document numbering convention. Therefore I would like the ID field to insert text before the ID number (but in the ID number field) to define a new ID number. For instance:
If the ID number was 001 and the type selected from the list box was Bylaw, I want BYL to be inserted before the ID number, creating a new ID number of BYL-001 (or if it were a policy POL-001 or a resolution RES-001, etc).
Does this make sense and is it possible?
Thanks.