I'm working on an Access db that tracks do***ents from initial creation
through a sign-off and release process. Each do***ent needs to be assigned
a
unique identifier of a specific format (out of my control) and there
cannot
be duplicates. Ultimately there may be 1000s of do***ents in the system.
Here
is the alphanumeric format I'm stuck using: XXXYYZZZZRR – WWW
XXX is actually a fixed assigned number (Ex: 301)
YY is a designator that may be 1 or 2 characters (Ex: "A" would indicate a
model, "AA" would indicate a drawing, "D" a do***ent, "TR" is training
manual, etc)
ZZZZ is the semi-unique numeric identifier (Ex: 2001, or 4432, etc)
RR is the revision/version ID and starts with A and goes through ZZ
-WWW is a numeric tag indicating sequence for a specific drawing or
assembly
(Ex: -001, -005, etc)
Sample Do***ent Numbers:
301D2004F-001 --> A stand-alone do***ent (Rev F) for the 2004 installation
301TR3353C-000 --> A training procedure (rev C)
301A2122BB-000 --> The 2122 Model (Rev BB)
301AA2122BB-002 --> Drawing (Rev BB) for part -002 of the 2122 model
301AA2122BB-003 --> Drawing (Rev BB) for part -003 of the 2122 model
I am trying to figure out an efficient method to set up the do***ent ID
that
will allow them to be sorted by the "YY" type and automatically
incremented
by the "ZZZZ" ****tion (or ZZZZ-WWW if necessary) so that when I assign the
next do***ent number, I don't inadvertantly repeat them.
If any of you MVPs or other Access experts out there has some sage advice
to
offer, I'd greatly appreciate the help/insight!
Thanks, much!
|
