Just what I needed. This will be a repetitive process: as I understand it whenever I make change to layouts, scripts etc. my db will need to import all of the previous data into my new version. If there was another way to do it I would love to know how! Thanks Steve!
-----Original Message----- From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Steve Cassidy Sent: Monday, December 15, 2008 9:04 AM To: [email protected] Subject: Re: Auto-number Ron If this is a once only thing, and you are not dealing with dozens of tables, you'll probably find it easier to do it manually. Just open up the field definition and reset the next serial number. If you have to do this regularly or if your end-users are going to be doing the imports, then you will have to script it as part of the import process. In pseudo-script, you do something like this: Import Records Sort (by serial number) Go To Record (Last) Set Variable $last_serial (to serial number of current record) Set Next Serial Value (choosing your serial number field and using $last_serial as the calculation) (So in fact Set Next Serial Value is the script step you are really looking for here...) HTH Steve On 15 Dec 2008, at 13:52, Ron wrote: > Having, I hope, solved my 3 level relationship, on to the next! > I am importing a number of tables from a Conversion database. > \Many of the tables are "child" tables which have an auto-number > increment. > The import works fine, retaining the old numbers, but the base > number for increment then needs to be set to one higher than the > last record. > I have not found a function that will do that, and it sure doesn't > happen automatically! > Any ideas? > Once again, many thanks to all of those who help out! > Ron Carr
