Re: Record # w/o being serial, forgotten how? [FMP6]

On Wed, 14 Sep 2005 14:11:07 GMT, "Matt Wills" <I'm@xxxxxxxx> wrote:

>Cerulean wrote on (9/14/2005):
>
>>I upgraded an old solution and it has record #'s in serial format.
>>I'd like to remove this to that type that no matter how you sort, the
>>first record is #1, as it were, even though each time it'll be a
>>different record that is #1. I just unticked the serial feature in
>>the properties, but that didn't work.
>>
>
>That serialized field is an "artificial" value created by the developer.
>FileMaker has its own built in values.
>
>What you want is FM's Record Number, changes with every find and every
>sort, representing the record's place in the found set at that time. See
>the Get (RecordNumber ) function in Help.
>
>Change that serialized field to a calc = Get ( RecordNumber ).
>
>Conversely, there's the Record ID, which FM assigns when a record is
>created and never changes. Record ID is unique to each record in each
>table in your file. See the Get (Record ID ) function in Help.
>
>Matt

Matt, thanks! Can you tell me where in help? I've done numerous
searches and nothing! <sigh> Very frustrating. Tx.

.

Relevant Pages