AnsweredAssumed Answered

No serial numbers when importing records

Question asked by KiminIL on Oct 21, 2009
Latest reply on Jan 13, 2011 by blewvelvet


No serial numbers when importing records


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?