AnsweredAssumed Answered

Serial numbers - consecutive numbers for non-consecutive records

Question asked by aikiko on Jul 11, 2010
Latest reply on Jul 14, 2010 by aikiko

Title

Serial numbers - consecutive numbers for non-consecutive records

Post

Dear All,

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,

Aikiko

OSX10.6 FMP10Adv

Outcomes