Reorder Record ID

[paperbag1]

In FM7, is it possible to reorder the record ID? The record Id matched the Order ID field until some records were deleted. The records have been recreated but there is a group that doesn't flow in sequence. I know I can sort the records and get what I need but I would like to have them match if possible. There aren't that many records and I am willing to reorder them manually if It can be done.

Phil

[RalphL]

If by record ID you mean the number you get with the Get(RecordID), the answer is no. I haven't tested in FMP7, but in earlier version this number was not a continous sequence. There were big breaks in the sequence at several places.

[paperbag1]

Not what I wanted to hear but thanks.

Phil

[Vaughan]

The RecordID is an internal number that FMP uses to track records. As Ralph says, the internal RecordID numbers are unique but are not contiguous.

FileMaker Inc specifically warn NOT to use the record ID for key fields or record identifiers, as the RecordID will change when records are imported between databases. (That is, you export the records out, import them back in into an empty clone of the same file and the RecordIDs will most probably be different.)

If you need your own record id, create an auto-entered serial number.

[jim lee]

Oh ohh.. I just started using this handy record ID for my key fields. Where'd you read that FM doesn't like that idea?

-jim lee