Add sequencial number depending the criterion

[cabete]

Hello Everyone i am making on Program to Track Drawings , number, section, maquine, how make it, where, how change it , revision and so one.
Right not step by step already make some things, but i am stopped, my knowledge are not much.

I want record one drawing with determinated choose, but i have one fild the number that should be automatic numeration with one rule.
See if exist one and if exist +1, if not exist record like 000.

Today its making sequencial number, but is missing see if exist and making like a sequencial number for my choose above.

Can anyone help me.
Tanks

 

[arnelgp]

afaik, drawing revisions are compiled.
from 0 to the last revision, it must be recorded.
with 1 record each.
you do not just replace the drawing's revision number.
this make it easy for traceability. to compare the previous revision from the latest.
what was added, deleted, updated.

EDIT: assigning revision number is done by Engineering group.

 

[cabete]

Small explanation about our numbering rule.
But i want keep all drawings. all the time new.

Example:
A.01.DEC.0004.011.000

A-Revision 1 if has B its Revision 2
01 its section of the plant
DEC.0004 - Machine
011 - type of tooling from the machine ( electric schematic its 002, etc etc)
000 - sequencial number


My problem its the sequencial number its all the time add+1 idependent of the family, but i want verify first last number from the family and add +1

 

[Pat Hartman]

Here is a data base with two samples of generated sequence numbers within a group. The process is much easier if all the parts are kept in separate fields and then you can keep a mushed field if you have to.

 

[cabete]

Tanks but not understand it. Any guide. or another example