a single shared variable

[Curtis_B]

We have an invoice counter field which is global. It basically just keeps track of the next invoice number to use. We need this to simulate an auto-increment (although it can't actually be an auto-increment for reasons I won't get into here). As it stands, we use a global field, which works great for one person, but of course does not work well for multiple people. I'm trying to figure out how I can setup this invoice counter to stay current across multiple users. Any input would be appreciated. Thanks, Curt

[David Jondreau]

How about a button that says "Enter Invoice Number". Click that and it runs a script grabbing the next serial number and then set fields.

"Grabbing the next serial number" is something you'll have to work out on your own without offering more information.