AnsweredAssumed Answered

Two different sets of serial numbers

Question asked by SamuelWeiller on Jan 13, 2014
Latest reply on Jan 13, 2014 by philmodjunk


Two different sets of serial numbers


     Hi All,

     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?