2 Replies Latest reply on Oct 19, 2009 3:19 PM by vanmi128

    How to carry on serial numbers on import



      How to carry on serial numbers on import


      This should be easy, but I can't get it to work.  I have a database of encounters with animals.  I've got a number field called "encounter number" which I have set up to automatically enter a serial number by an increment of 1.  New encounter records are added to my database by importing multiple records from an excel worksheet.  When I import new encounters I would like my "encounter number" field to automatically enter the 'next' number (e.g. if I have 420 encounters in my filemaker database and I import 2 new encounters, the encounter numbers 421 and 422 should automatically enter), but it keeps starting back at number 1 and incrementing from there.  In the field options I have tried changing the 'next value' that the serial number should enter, and I have tried specifying that it should be a 'unique value', but the encounter number of new imported records still keep restarting at number 1.

      I am using FileMaker 10 (windows).