Records ID calculation gestion

[DBlombago]

My question has already a kind of answer on this forum but it was for older version of File maker (5,6) and the solution does'nt seem to work.

 

The problem is described to this link:

http://filemakertoday.com/filemakertoday.com_non_ssl/com/showthread.php?t=237

 

If I create a "new records", counted by a serial number auto (1,2,3,4,5 etc) and that I delete the number 3, I don't want the records to be classified like (1,2,4,5,6) with an empty ID number, but all the number ID need to be raplace correctly. If a new record is crated, the "#3" will be used has the new record and not the "6)

 

I need a script that work with File maker Pro 8

Thank you

[Ender]

I suggest you re-read that thread, and think about why it should be necessary to reuse ID numbers like this. If this ID is meant for a relational key, then you should not reuse the IDs as it introduces the likelyhood of creating links to the previous record's orphaned children.