Sequential Numbering with Codes

[dbeck]

I'm trying to script the creation of new "job numbers" in a 'job order" database. I have client codes like, APA-, JAS-, EAG-. The numbering system that I want to create is sequential and goes; APA-1, APA-2, APA-3, APA-4, JAS-1, JAS-2 etc. I just want to create a new number in sequential order for each new record within a client code, when the new record is created.

Each client code will go from -1 to -999 at most.

Ideally, the user will create a new record, type in their client code, hit tab, and the next consecutive number for that client code will pop-up and be un-alterable.

I am new to Filemaker, and I can't seem to get this working through scriptmaker.

[MoonShadow]

I believe this demo file will help you:

Independently Incrementing Serial Numbers