Script to go to record with highest # in a field

[ibiubu]

I have a database that uses a field that auto-enters a serial number in a field everytime a nw record is created.

Would there be a way to create a script that would go to the record where the field named "serial" contains te highest number?

LR

[LiveOak]

The highest numbered record is always the last record entered:

Show All Records <--- if you mean THE the highest number, leave out for "in the current found set"

Unsort

Go to Record/Request/Page (Last)

-bd

[Vaughan]

If it's not always the last record, you could use the script

Sort [by serial number, descending]

Go to record [first]

[Fitch]

Sounds like you're looking for something fancier, so here you go.

Create the following:

1. A calculated field "constant" that = 1

2. A self-join, "constant," that is constant::constant

3. A calculated field "theMax" that = Max(constant::serial number)

4. A self-join, "eureka," that is theMax::serial number

5. Now make a script and/or button to Go To Related Record (eureka)