Is there a better way > Auto Enter Serial Number in FMPro 9?

I've been searching for a couple days now for the solution to
resetting the "Record Number" in my database. The Record Number is a
Serial Number and should increment by 1.

The problem I'm having is whenever a record is deleted (usually the
last record entered), my numbering is off, and I have to manually
reset the Serial Number before someone inadvertantly starts a new
record.

For example, if my records are 09, 10, 11, 12, and record 12 is
deleted, the Serial Number will then install 13 as the next available
record number.

I was able to locate this simple looking enough script from the web:

Enter Browse Mode []
Allow User Abort [Off]
Show All Records
Unsort Records
Go to Record/Request/Page [Last]
Set Next Serial Value [Client Records::Record No + 1]

The problem is, I can't get it to work. Anybody out there have a
solution?

Thanks in advance!

.

Relevant Pages

  • Re: VB Scripting
    ... > Script to pull out the user name and phone number: ... > It all appears to work ok, but when I check the logs from the script it ... > appears to only be searching through the first 1000 users in the database. ...
    (microsoft.public.win2000.active_directory)
  • VB Scripting
    ... I'm connecting to our AD database using the following statements in a VB ... Set objConnection = CreateObject ... It all appears to work ok, but when I check the logs from the script it ... appears to only be searching through the first 1000 users in the database. ...
    (microsoft.public.win2000.active_directory)
  • RE: Database running over network runs extremely slow
    ... I have reports built into the database that track the entry ... you are searching (or using in your DLOOKUPs criteria parameter)? ... of the DLookups to looped recordset searches, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How many names and addresses can you have for ID card
    ... large amount of database space, ... Searching CLOBs is thus memory and CPU-intensive, ... A directory system a la LDAP or X.500 would be a much more natural ... An entry may have any number of atrributes which are ...
    (uk.legal)
  • Re: Exporting Text field line entries to individual records
    ... Been doing alot of searching on this group, and have not come up with ... Stuff that is entered in the field, followed by a carriage return: ... manually, except that are thousands of SP's in this database, and some ... calculation field that selects text between carriage returns. ...
    (comp.databases.filemaker)