Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Generating ID number


Recommended Posts

Bit of a weird one, I think.


In my contact database, it will be optional for the people to join an association. I would like to have an association number entered, on pressing a check box to say they are a member of the association.


The number needs to be in the format ACT 1000 incrementing by one each time another contact becomes a member, i.e. each time that is selected.


Hopefully that makes sense So Cool!

Link to comment
Share on other sites

Ok I've done what I think is a dirty way of doing this.


I've created another table called ACT ID, then made a script, which created a new record in this table, copies the ACT ID, and pastes it back into the ACT ID field in the contacts table.


Not great, but a way around it smiley-sealed

Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use