Reset Record ID in a table.

[rshacklett]

Anyone know of a way to reset the Get(RecordID)?

I've got a table that is extensively "wired" with a million relationships that does a bunch of processing (creating records, process and then delete) and the RecordID is up around 500,000,000. The only problem is that I'm using XML requests to get the data, and those large record ids are just adding a lot of extra data to the XML output. Plus I'm wondering if that large rec id is slowing down new record creation?

I can easily delete all of the records in the table, but that doesn't seem to reset it, nor does doing a "recover", or "file maintenance".

I'm open to any ideas! ...even if there is a program that will copy a fm database file to a new file and replicate all relations, scripts, value lists and layouts to create a "fresh" duplicate file.

Thanks for everyone's ideas! Ryan

[comment]

Save a copy as clone (no records), and import your records.

[rshacklett]

Excellent! That will work for me! Thanks!