Generate Serial Number Button?
I need to know if its possible to generate a new serial number usinig a button, so that only records that require a new number get one.
I have a contact management database that manages our Museum's entire contact list. This includes our membership database.
Each record has a serial number assigned on creation but I would also like the ability to assign a Membership Card number to members. Not everyone in our database is a member, so I don't want it to generate a card number on record creation, only when they join as a member.
I would like to have a button that generates a membership card number when its clicked.
Is this possible?