I'm working on a do***ent control database (assigns do***ent numbers and
tracks a do***ent from inception to release and through revisions and
signature approval process). Thanks to help from this forum, I've worked
out
a multi-field "ID" system to meet the requirements for the do***ent
numbering
system and set up a query to display the do***ent number with the multiple
fields concatenated. Essentially:
FORMAT: XXXYYZZZZRR-WWW
Examples: 301AA2112B-000, 301D1492BB-002, 301TR1973A-003
Each set of letters is its own field (XXX is the main designator, YY is
the
do***ent type, ZZZZ is the numeric series for the do***ent, RR is the
revision increment, and -WWW is essentially identifying multiple parts in
an
assembly).
For sorting and assigning new numbers, I'm only concerned with the
XXXYYZZZZ
section and my query fills a table with the do***ent numbers' individual
fields and a separate index with the concatenated "ID" XXXYYZZZZ. I've set
this to presort based on ascending values for these three pieces.
I would like to set up another query or form that increments to tell me
the
next available do***ent number in the ZZZZ series, based on which YY I
select
(for now, all the XXX indicators are the same, i.e. "301"). This will
allow
me to issue new numbers for do***ents without having to run a re****t to
scan
through all the numbers or manually go through the table. That's the goal
anyway.
I appreciate any insight offered! Thank you!
Liane
|
