10 Replies Latest reply on Jan 13, 2011 3:17 PM by blewvelvet

    No serial numbers when importing records

    KiminIL

      Title

      No serial numbers when importing records

      Post

      I am designing a database in Filemaker Pro Advanced 10.0v3. When I import records from an Excel file, everything works great except the database does not generate an ID# (serial #) for any of the imported records. The ID# field is set to auto-enter on creation.

       

      I tried setting the field to auto-enter on commit but that didn't change anything. This seems like a pretty straightforward task - I wouldn't think Filemaker would get confused because there are multiple records created at one time but maybe that's why it won't create the serial numbers.

       

      I have been using Filemaker for a long time but I am very new to developing a database.

       

      Any suggestions on how to get it to create a serial number for each record I import?