Re-Order RecordID

[radius360]

Hi,

I'm relatively new to Filemaker and I'm having a bit of an issue. Not sure if this is the right category.

I've created a set of records using auto enter serial (numbered M001-M400 for example). I've created a layout that shows all records in a list. At some point i must have deleted the first record by accident. I created a new record and changed the serial number to M001. Now when i go to the list M001 is at the bottom, after M400. From what i understand this has something to do with the unique number that Filemaker applies to each record?

That being said, what is my best approach to fix the problem? Can i change the FM RecordID or do i need to make a sort script for when i enter this layout?

Many thanks!

[comment]

Do you mean you want to reconstruct the first record AND have it appear first when records are unsorted (i.e. sorted by creation order)?

[radius360]

Yes, that's correct.

[comment]

Sort the records by serial and export them. Delete all records and import the exported file. Finally, reset the serial number field to pick up from the last serial forward.

Make sure you have a backup before you try this.

[radius360]

That worked! Thank you!

[Vaughan]

Sort the records by serial and export them. Delete all records and import the exported file. Finally, reset the serial number field to pick up from the last serial forward.

Make sure you have a backup before you try this.

Ummm, don't delete all records if there are related tables set with cascade deletion -- they too will be deleted. Instead import the data to overwrite the found set.