Chris_J Posted March 27, 2008 Share Posted March 27, 2008 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 More sharing options...
Chris_J Posted March 27, 2008 Author Share Posted March 27, 2008 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 More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts