Two different sets of serial numbers
I am making a database of research participants. Each participant is given a basic serial number regardless of what type of experiment they participate in. However, certain participants are given a second serial number if they are in one type of experiment. What I would like to do is to have a script button someone could click to assign the secondary serial number if it is needed. I have tried making the following script:
Set Field ( Subjects::ScannerID ; Max ( Subjects::ScannerID ) + 1 )
but this start back at 1 for each record. Any idea how to do this?