Jump to content

No Serial Numbers??

This topic is 6465 days old. Please don't post here. Open a new topic instead.

Recommended Posts


Ok. Having a very strange issue. I have a field set as my serial number. It's a number, with the option to auto-enter a serial, incrementing by one.

But when I try to replace it's now empty contents (There are many records already, but I only just added the field itself) with a serial number in the Replace Dialog, it seems to process, but the field is still left blank at the end.

I tried creating a new field, again with the same results.

I then tried creating a script which went like this:

GTRR [first]


Set Next Serial Value [invoice,myfile::invoice + 1]

GTRR [Next, exit after last]

End Loop

This also appeared to be doing something, going through each record. When it was done, there were still no serials.

I then tested to make sure numbers could be manually entered in the field, and starting with 1, successfully entered incremental numbers in the field in each record. They were maintained.

I'm using FMP7.

Can someone please tell me WTH is going on...?

All My Best,


Edited by Guest
Link to comment
Share on other sites

Your script is setting what value the table should use when it next creates a record--and not the value in the actual record. In other words, you're going through and repeatedly telling the table "when you create a new record, use the following number: " To achieve what you're shooting for, you'd need to use the "Set Field" to set the value in the record.

However, the Replace Contents command should work in this situation. What exactly are you using in the command? Check the help file on this, and use the Replace with serial numbers option, starting with 1. Then check the Update serial number in Entry Options to ensure that the NEXT record gets the next Serial (or run your script again... : )



Link to comment
Share on other sites

This topic is 6465 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.