Serial numbers - consecutive numbers for non-consecutive records
A tricky problem that I cannot solve.
My DB has 2 serial numbers for each record: 1) database serial number for each record that is entered and 2) a serial number that is called ID number for each record that is of interest.
Automating the database serial number is straight forward, but how does one create the calc for the ID number so that every time a yes/no checkbox in the field ('ID number required') is clicked yes, then the ID number is automatically created.
Of note, the ID number should be a consecutive number, but for non-consecutive records, for example:
DB Serial no =1 ID number=1
DB Serial no =2 ID number= not required
DB Serial no =3 ID number= not required
DB Serial no =4 ID number=2
DB Serial no =5 ID number=3
DB Serial no =6 ID number=not required
DB Serial no =7 ID number=4
Many thanks in advance for any assistance provided once again,