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?