Jump to content

Reset Serial Number?


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

Recommended Posts

Greetings. I have an FM database with about 1400 records in it, but my I have a field reqNum (request Number) that is 1500 or so, due to record deletions (some users can delete bogus requests). The 'reqNum' field is a Serial number and I want it to reflect the current count.

In MS Access, you can compact your AutoNumbers so they all go in order.

Can one do this in FileMaker? Go through each record and reset reqNum back, so that each record is in numerical order?

Link to comment
Share on other sites

What differences does break in numbers make? After all, they are only numbers.

You can "Replace" your serial numbers using the Menu - Records - Replace. But, I can not think a valid reason to do so. However, I can think a few valid reason *not* to do so.

If you insist on proceeding however, test what you are doing on a copy of your database, *not* the original or only copy.

Lee

Link to comment
Share on other sites

I agree with Lee -- don't change serial numbers. The point of a serial ID number is that it is at least the one field in a record that won't change. Ever. It will always be the 'key' field, to use Access verbage. If you want something that reflects the current count, then use status(CurrentRecordCount) fur tne number of records in the file, or status(CurrentFoundCount) that shows how many are in the current found set.

Dan

Link to comment
Share on other sites

This topic is 7463 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.