I have a question about using a field that uses Status(CurrentRecordNumber)?

When I create a new record it places the current record number in the field. For example if I have 5 records and create a new one it placed 6 in the field. Now if I go in and delete 2 records records then my total number of records left are 4. Yet the field for my newly created record still reads 6.

Is there any way to have this field update in all my records to always match the current state of records?

The same problem applies to Status(CurrentRecordCount). Looking for a solution for it also.

LR

It sounds like you want a calculation field, but that you now have ordinary text or number fields with an auto-entered calculation in them. You could also have mistakenly have left indexing turned on.

If they are ordinary fields, then you could just change the fields to be calculation fields, where the calculation would be Status(CurrentRecordNumber) and Status(CurrentRecordCount). Also, don't forget to check the "Do not store calculation result..." checkbox in the indexing options of the calculation fields. Otherwise they will not always be up to date.

Good luck!

Daniel

As far as I know, Status(CurrentRecordNumber) just returns the internal ID of the record that FileMaker itself uses to track recrods.

Like mentioned before use Status(CurrentRecordCount)....

Turn the indexing for the calc field OFF. This should update the numbers correctly.

quote:

---

As far as I know, Status(CurrentRecordNumber) just returns the internal ID of the record that FileMaker itself uses to track recrods.

---

Eric,

It is the Status(CurrentRecordID) that returns the internal ID of a record.

That is completely different from the Status(CurrentRecordNumber).

Here's some more detailed information from FileMaker's tech info database:

"The Status(CurrentRecordID) function was included in FileMaker Pro 4.0 and later; primarily as an aid to web publishing and cgi functionality. It provides access to a unique ID that is specific to one record in the database regardless of the current found set or sort order. This is in contrast to the Status(CurrentRecordNumber) which changes based on current found set or sort order. The ID numbers FileMaker Pro generates are sequential but not contiguous due to the way the numbers are generated internally. It is not intended to be used as an incremental serial number, counter, or other similar function."

Just some clarification,

Daniel

Great stuff. It worked out perfectly. Good call. And yes, I had the field as a text field with a auto enter using the Status(CurrentRecordNumber). As soon as I switched the field to a calculation and changed the storage options as stated above it all worked llke a charm.

LR

Also, make sure the "Do not store..." box is checked.

DanielS: Oops, my bad.