Hi,

One small question, I will some be switching my solution from 6 to 8.5, I'm
redoing my hole solution from scratch, and I create some dummy records to
test scripts and relation etc etc....
this could be easy to test, but when saving to a clone file, will all FM
Records ID set to null and start all over again ?

JF

To my knowledge, no. The ID stay where it was. But if you import records,
either you import old IDs or you have some choices to redo the ID if it was
set as filling itself automatically. But I would not advise to use that last
option as there maybe holes in the numbering and the ID value is so
important as it is used in relationships and scripts, that I wouldn't touch
it. Except after import, and 'see all records' then sort by ID, I would
check the highest ID and look at the field ID definition to see if it really
is now set to the 'highestID + 1'.
But as you said, why not try it out ?
Remi-Noel

"JF" <bizouman_takethisout (AT) hotmail (DOT) com> a écrit dans le message de news:
g40oh.80598$WB6.799744 (AT) wagner (DOT) videotron.net...

In article <g40oh.80598$WB6.799744 (AT) wagner (DOT) videotron.net>, "JF"
<bizouman_takethisout (AT) hotmail (DOT) com> wrote:

That really depends on what you mean by "Record ID".

If you have created a field to give each record an ID number using an
auto-enter serial number, then when you Save As to a Clone file this
will NOT reset back to whatever their initial values were. Those
initial values are not kept anywhere (only the "next" value is stored),
so you'll have to do that manually or use a script that contains the
Set Next Serial Value command. You could even have an Opening script
that uses this command to reset the field(s) if there are 0 records in
the database.

If on the other hand you mean FileMaker's own internal Record IDs, then
when you Save As to a Clone file these DO reset back to "0" (the first
new record will be "1" again). This is a unique ID given to every
record by FileMaker itself so that it can keep track of it. This can
internal ID be useful for creating your own "Record ID" field by using
the Status(CurrentRecordID) function, which is probably now called
something like Get(CurrentRecordID) in newer versions of FileMaker.

Obviously resetting the ID field(s) automatically is not a good idea if
your system moves old records to another file (eg. at the start of each
year) and you still want the ID numbers to continue in sequence.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)