June 14, 200421 yr Newbies 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.
Create an account or sign in to comment