1,Show All records. Drop cursor in ID field. Select REPLACE from records menu - replace with sequentials.
2. Script it.
Show All Records.
SetVariable ($Count; 1)
Go First Record.
SetVariable ($Count; $Count + 1)
Go Next (exit after last)
How do I create a way to add sequential ID#'s in the data base, without having to repetively type in 400 #'s individually., now that I converted the spreadsheet to a product database?
Create a new field and set the options to be a serial number. Put the field onto a layout and use the replace function to set the serial numbers.
Easiest way is to first define the table in FileMaker with seq# and then do the import to that table. If you already did the import just use that table delete all records create seq# field the re-do import to that table.
The fastest way I've found is to (back up first) change the serial number from number to type calculation (result is number): Get ( RecordNumber )
Do NOT make it unstored ... exit out of definitions and make note of the table total count. Because calc is stored, it's value plants into the fields. Then go back to definition and change back to regular number ... value will remain. Set the auto-enter serial to total count + 1.
It handles all records without showing all records first which wasn't mentioned (but needed) with the other techniques. You don't have to find the field on a layout or create script. It also respects the natural sort order of creation even if the table or relationship is sorted. It is much faster than setting a field but beware of record locking. Working in definitions when users are in system is risky anyway; best to avoid it.