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

#11

Cerulean wrote on (9/17/2005):

Quote:

On Wed, 14 Sep 2005 14:11:07 GMT, "Matt Wills" <I'm (AT) Witz (DOT) end> 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.

Probably my fault. If you looked for RecordID (no space), it would have
turned up right away.

In the Get Functions. Functions Reference (category list)

Matt

--

#12

Damn, no.

It wasn't RecordID you wanted, rather RecordNumber. Typing that combined
word in the search returns Get(RecordNumber) just fine.

It's in the Get Functions of the Functions Reference.

Matt

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.filemaker comp.databases.filemaker

Re: Record # w/o being serial, forgotten how? [FMP6] - 09-17-2005 , 07:56 PM

Re: Record # w/o being serial, forgotten how? [FMP6] - 09-17-2005 , 07:59 PM