1 Reply Latest reply on Sep 11, 2009 5:43 PM by comment_1

    Newby Question on Auto Serial Number



      Newby Question on Auto Serial Number


      <!--  StartFragment  -->

      I am setting up an accountingform, and I want all payments from one department to be sequentially anduniquely numbered 1001, 1002, etc, while all disbursements from another department will be sequentially 2001, 2002, etc, and with a different number for eachof the other 3 departments, with all numbers to be automatically entered by the computer.  


      The auto enter serial numbers in the define fields modes certainly works fine for one department, but how do I have it enter different numbers for each department? I originally thought maybe a field which a radio button for department 1, 2, etc. and then another field, with an “if then…else” statement. But,I became so confused, I thought a martini with two olives would be a better solution for my immediate headache.


      Any ideas on how to solve the serial number problem? I’m very grateful for any help. FileMaker 10 looks like a great program.



      Ted H

      <!--  EndFragment  -->