I have a pretty complex databases composed of numerous tables. I have an Auto Enter assign a Primary Key ID fields.

The problem is when I try importing new records, it messes up the ID fields.

To update my database -At times- I need to import several records from a newer file, TO do that I have a script to import several tables at the same time.

Because of the database structure; I have to uncheck (Turn off) the "Perform Auto-Enter while importing.

Because of that the newer records are imported to the older database. Everything is good. Now if you try to create a new records, While the ID Auto enter serial number should start a unique new number, it doesn't. Instead it creates the next serial value. WHich creates duplicate numbers. Messing up whole relationships and fields.

I know this is hard to explain, but I hope someone out there knows what I am talking about and could help.

Thanks

Set serial numbers manually or via

http://filemaker.com/help/Script-Steps39.html

Jens