When you say "Old database' and "new database" are they the same version of FM? If so, I would have just imported the new work into the old database, and avoid almost all of the data problems. If they are not the same version, I would still do the same, then import the entire old database into the new db, one table at a time.
Also did you uncheck "Perform Auto Enter options...."?
"auto enter options" should be left unselected and you should then update the "next serial value" setting on all auto-entered serial number fields. This can be done manually via Manage | Database or via a script. (I often set up a script that does the full import into a cloned copy of the database with script steps to update each auto-entered serial number field.)
Steve - yes it is the same version of FM. I tried importing the old work into the new work, but it created more problems than it solved.
Thank you Phil, I guess I'll get busy. I think I can update them faster than I can write and debug a script.
Thank yo both for your help