AnsweredAssumed Answered

Unique IDs for only certain records

Question asked by SamJaques on Feb 11, 2014
Latest reply on Feb 13, 2014 by SamJaques


Unique IDs for only certain records


     I'm trying to build a database of people involved with a medical clinic where most but not all of the records in the table are for members of the clinic. Each member needs a unique membership number, and these numbers should only increment with the addition of members, not with the addition of other people in the database.

     Is there any way I can set a field to automatically generate a unique membership number by incrementing past the last membership number, but only when the "Member" field is set to "Yes"?