next in the list: serial id number

#1

How do I do this ..

....a field that displays a number matching the next new record's auto-
entered serial id.

If I sort existing records by id, then go to last record and grab the
value of that last record (and add 1), I can't be sure the grabbed id
belongs to the last created record...the last created record may have
been deleted.

any ideas ?

marmot

#2

In article
<1183830568.915150.264820 (AT) 22g2000hsm (DOT) googlegroups.com>thdyoung@go
oglemail.com wrote:

Quote:

How do I do this ..

....a field that displays a number matching the next new record's
auto-entered serial id.

If I sort existing records by id, then go to last record and grab
the value of that last record (and add 1), I can't be sure the
grabbed id belongs to the last created record...the last created
record may havebeen deleted.

any ideas ?

marmot

GetNextSerialValue ( fileName ; fieldName )

Matt

#3

On Jul 7, 7:24 pm, Matt WIlls <I... (AT) Witz (DOT) End> wrote:

Quote:

In article
<1183830568.915150.264... (AT) 22g2000hsm (DOT) googlegroups.com>thdyoung@go

oglemail.com wrote:
How do I do this ..

....a field that displays a number matching the next new record's
auto-entered serial id.

If I sort existing records by id, then go to last record and grab
the value of that last record (and add 1), I can't be sure the
grabbed id belongs to the last created record...the last created
record may havebeen deleted.

any ideas ?

marmot

GetNextSerialValue ( fileName ; fieldName )

Matt

easy! thanks Matt.

marmot

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

next in the list: serial id number

comp.databases.filemaker comp.databases.filemaker

next in the list: serial id number - 07-07-2007 , 12:49 PM

Re: next in the list: serial id number - 07-07-2007 , 01:24 PM

Re: next in the list: serial id number - 07-07-2007 , 03:07 PM